options ls = 100 ps = 100;

libname in "/data";
libname nsc "/data";

%include "/data/nsc_formats.sas";

DATA major_list (keep = major major_group);
	SET in.nsc_cleaned_forsas (keep = major College_Name tuedt2003 Degree_Title);
        if Degree_Title ^= " ";
	* length major_group $20;

/*  Agriculture */
	if Major = 'AQUACULTURE' then major_group = 1;
	else if Major = 'CROP PRODUCTION OPT' then major_group = 1;  
	else if Major = 'DAIRY SCIENCE' then major_group = 1;  
 	else if Major = 'EQUINE SCIENCE' then major_group = 1;  
  	else if Major = 'EQUINE STUDIES' then major_group = 1;  
  	else if Major = 'FARM OPERATION & MGMT' then major_group = 1;  
	else if Major = 'PLANT AND SOIL SCIENCES' then major_group = 1;
	else if Major = 'PLANT SCIENCES & LANDSCAPE SYS' then major_group = 1;
	else if Major = 'POULTRY SCIENCE ( SCIENCE)' then major_group = 1;
	else if Major = 'LANDSCAPE/NSRY, GARDEN CTR MGT' then major_group = 1;
	else if Major = 'CONSERVATION & RESTORATION ECO' then major_group = 1;  
	else if Major = 'SOIL AND ATMOSPHERIC SCIENCES' then major_group = 1;
	else if Major = 'WATER RES-GROUNDWATER' then major_group = 1;
	else if Major = 'RESOURCE CONSERVATION' then major_group = 1;
	else if Major = 'AG PRODUCTION' then major_group = 1;  
  	else if Major = 'FLORAL CAREERS' then major_group = 1;   

/*  Architecture and Urban Planning */
	else if Major = 'CITY AND REGIONAL PLANNING' then major_group = 2;  
	else if Major = 'COMMUNITY & REGIONAL PLANNING' then major_group = 2; 
	else if Major = "COMMUNITY DEV'L & PLANNING" then major_group = 2;  
	else if Major = 'COMMUNITY DEVELOPMENT' then major_group = 2;  
	else if Major = 'COMMUNITY DEVELOPMENT & PLANNING' then major_group = 2;  
	else if Major = 'HISTORIC PRESERVATION & COMM PLANNING' then major_group = 2;  
	else if Major = 'REGIONAL PLANNING' then major_group = 2;   
	else if Major = 'WOODROW WILSON M.P.A.& U.R.P.' then major_group = 2;  
	else if Major = 'INTERIOR DESIGN TECHNOLOGY' then major_group = 2;
	else if Major = 'BUILDING SCIENCE' then major_group = 2; 
	else if Major = 'DESIGN' then major_group = 2;  
	else if Major = 'DESIGN STUDIES' then major_group = 2; 
	else if Major = 'INFRASTRUCTURE PLANNING' then major_group = 2;          
  else if Major = 'ARCHITECTURAL' then major_group = 2;
  else if Major = 'ARCHITECTURAL DESIGN GRAPH I' then major_group = 2;
  else if Major = 'CAD-ARCHITECTUAL' then major_group = 2;
  else if Major = 'CITY & REGIONAL PLANNING' then major_group = 2;
  else if Major = 'COM&REGNL PLN (COM PLAN&DEV)BS' then major_group = 2;
  else if Major = 'INTERIOR DESIGN BS' then major_group = 2;
  else if Major = 'URBAN AFFAIRS MA' then major_group = 2;
  else if Major = 'URBAN AND REGIONAL PLANNING' then major_group = 2;
  else if Major = 'URBAN STUDIES AND PLANNING' then major_group = 2;
  else if Major = 'URBAN STUDIES AND PLANNING-BA' then major_group = 2;       
  else if Major = 'BUILDING INSPECTION (AAS DEGREE)' then major_group = 2;

/* Area, ethnic, and gender studies */
        else if Major = 'AFRICAN AMERICAN STUDIES' then major_group = 3;
	else if Major = 'APPALACHIAN STUDIES' then major_group = 3; 
	else if Major = 'APPALACHIAN STUDIES                 I D   0391' then major_group = 3;     
	else if Major = 'AREA ST AS LA RU' then major_group = 3; 
	else if Major = 'ASIAN MIDEAST CULTR' then major_group = 3; 
	else if Major = 'BLACK STUDIES BA' then major_group = 3; 
	else if Major = 'CHICANO/CHICANA STUDIES' then major_group = 3; 
	else if Major = 'ETHNIC STUDIES                     ES        22991' then major_group = 3; 
	else if Major = 'LSJ - CHICANO STUDIES' then major_group = 3; 
	else if Major = 'LSP - CHICANO STUDIES' then major_group = 3; 
	else if Major = 'ETHNIC STUDIES' then major_group = 3; 
	else if Major = 'LAT AM, CARIB & IBERIAN ST BA' then major_group = 3; 
	else if Major = 'MAJOR IN ASIAN STUDIES' then major_group = 3; 
	else if Major = 'NEAR EAST STU' then major_group = 3; 
	else if Major = 'SOUTHERN STUDIES' then major_group = 3; 
	else if Major = 'EAST ASIAN STUDIES - CHINA' then major_group = 3; 
	else if Major = 'INTERCULTURAL STUDIES' then major_group = 3; 
	else if Major = 'AFRO-AMERICAN STUDIES' then major_group = 3; 
	else if Major = 'AMERICAN STUDIES' then major_group = 3; 
	else if Major = 'AFRO-AMERICAN STUDIES PH D' then major_group = 3; 
	else if Major = 'AMERICAN CULTURE' then major_group = 3; 
	else if Major = 'ASIAN AMERICAN STUDIES' then major_group = 3; 
	else if Major = 'LIBERAL STUDIES: AMERICAN STUDIES' then major_group = 3; 
	else if Major = 'MEXICAN-AMERICAN STUDIES - BA' then major_group = 3; 
	else if Major = 'MAJOR: AMERICAN STUDIES' then major_group = 3; 
	else if Major = 'LATIN AMERICAN STUD' then major_group = 3; 
	else if Major = 'LATIN AMERICAN STUDIES' then major_group = 3;
	else if Major = 'AMERICAN STUDIES PH D' then major_group = 3; 
	else if Major = 'AFRICAN AREA STUDIES' then major_group = 3;
	else if Major = 'AFRICANA AND ARCH STUDIES' then major_group = 3; 
	else if Major = 'AFRICANA STUDIES' then major_group = 3; 
        else if Major = "ASIAN STUDIES" then major_group = 3;
        else if Major = "CHICANO STUDIES" then major_group = 3;
        else if Major = "EAST ASIAN STUDIES" then major_group = 3;
        else if Major = "LIBERAL STUDIES: SOUTH ASIAN STUDIES" then major_group = 3;
        else if Major = "MA IN MIDDLE EASTERN STUDIES" then major_group = 3;
        else if Major = "RUSSIAN AND EAST EUROPEAN STUDIES " then major_group = 3;
        else if Major = "RUSSIAN STUDIES" then major_group = 3;
        else if Major = "ST OF WOMEN, GEND & SEXUALITY" then major_group = 3;
        else if Major = "WOMEN IN POLITICS" then major_group = 3;
        else if Major = "WOMEN'S STUDIES" then major_group = 3;
        else if Major = "WOMEN'S STUDIES BA" then major_group = 3;

        
/*  Biological, biomedical studies, and nature conservation studies */

  	else if Major = 'BACTERIOLOGY ANS' then major_group = 4;  
  	else if Major = 'BOTANY' then major_group = 4;  
  	else if Major = 'CELLULAR AND MOLECULAR PHYSIOLOGY' then major_group = 4;
  	else if Major = 'GENETICS' then major_group = 4;  
	else if Major = 'BIOLOGY: BIOMEDICAL' then major_group = 4;  
	else if Major = 'BIOMEDICAL' then major_group = 4;  
	else if Major = 'BIOMEDICAL SCIENCE' then major_group = 4;  
	else if Major = 'CELLULAR & MOLECULAR PHARMACOLOGY & PHYSIOLOGY' then major_group = 4; 
	else if Major = 'LELSE IFE SCIENCE' then major_group = 4;
	else if Major = 'LELSE IFE SCIENCES' then major_group = 4;
	else if Major = 'MARINE SCIENCE' then major_group = 4;
	else if Major = 'MARINE TECHNOLOGY' then major_group = 4; 
	else if Major = 'EPIDEMIOLOGY' then major_group = 4;  
	else if Major = 'LBS PHYSIOLOGY' then major_group = 4;  
	else if Major = 'INTEGRATIVE PHYSIOLOGY' then major_group = 4;  
	else if Major = 'PHYSIOLOGY' then major_group = 4; 
  	else if Major = 'NEUROSCIENCE' then major_group = 4;  
  	else if Major = 'NEUROSCIENCE AND BEHAVIOR' then major_group = 4; 
	else if Major = 'ENTOMOLOGY' then major_group = 4;    
	else if Major = 'HUMAN DIMENSIONS OF ECOSYSTEM SCIENCE' then major_group = 4;
	else if Major = 'CLIN LAB SCI: 2 YR UPPER' then major_group = 4;  
	else if Major = 'LIFE SCIENCE' then major_group = 4; 
	else if Major = 'LIFE SCIENCES' then major_group = 4;   
        else if Major = "CONSERVATION AND RESOURCE STUDIES" then major_group = 4;
        else if Major = "ENERGY AND RESOURCES" then major_group = 4;
        else if Major = "ENV SCIENCES POLICY & MGMT B S" then major_group = 4;
        else if Major = "GENETICS PROGRAM" then major_group = 4;
        else if Major = "INTERDISCIPLINARY: NEUROSCIENCE" then major_group = 4;
        else if Major = "MACROMOLECULAR SCIENCE & ENGIN" then major_group = 4;
        else if Major = "MAJOR IN GENETIC COUNSELING" then major_group = 4;
        else if Major = "MAJOR: ENV SCIENCE & MGMT" then major_group = 4;
        else if Major = "MAJOR: EPIDEMIOLOGY" then major_group = 4;
        else if Major = "MOLECULAR PATHOLOGY" then major_group = 4;
        else if Major = "NAT RESOURCE MGMT - CERT" then major_group = 4;
        else if Major = "NAT RESOURCES MGMT - DIPL" then major_group = 4;
        else if Major = "SUSTAINABLE DEVELOPMENT" then major_group = 4;
        else if Major = "WATER AND AIR RESOURCES" then major_group = 4;
     
/*  Business, management, and marketing */

	else if Major = 'LOGISTICS' then major_group = 5; 
	else if Major = 'ENTREPRENEURSHIP CERTIFICATE' then major_group = 5;
	else if Major = 'FIN-BANK/DEPOS INSTNS' then major_group = 5;
	else if Major = 'SUPERVISION' then major_group = 5;   
	else if Major = 'SALES' then major_group = 5;   
	else if Major = 'STRATEGIC LEADERSHIP' then major_group = 5;    
	else if Major = 'PURCHASING/LOGISTICS MGT' then major_group = 5;    
	else if Major = 'MRKTG-PURCH & MATERIALS MNGT' then major_group = 5;    
	else if Major = 'ORGANIZATIONAL COMMUN' then major_group = 5;    
	else if Major = 'ORGANIZATIONAL LEADERSHIP' then major_group = 5;  
	else if Major = 'TECH MANAGEME' then major_group = 5;   
	else if Major = 'COMPUTING & MANGMT' then major_group = 5;  
	else if Major = 'ENGINEERING MANAGEMENT' then major_group = 5;  
	else if Major = 'INDUSTRIAL & MANAGEMENT ENGR' then major_group = 5;  
	else if Major = 'MANAGEMENT SCIENCE MATH MINOR' then major_group = 5;  
	else if Major = 'MGMT SCI & ENGINEERING (MS)' then major_group = 5;  
	else if Major = 'MGMT SCI & ENGINEERING (PHD)' then major_group = 5;  
	else if Major = 'TECHNICAL SALES' then major_group = 5; 
	else if Major = 'REAL ESTATE SALESPERSON' then major_group = 5;     
	else if Major = 'REAL ESTATE' then major_group = 5;      
	else if Major = 'INSURANCE' then major_group = 5;             
	else if Major = 'MASTER OF SCIENCE IN TAXATION' then major_group = 5;
	else if Major = 'DECISION SCIENCES' then major_group = 5;  
	else if Major = 'MANAGEMENT INFO SCIENCE' then major_group = 5;  
	else if Major = 'MANAGEMENT INFO SYSTEMS' then major_group = 5;  
	else if Major = 'MANAGEMENT INFO SYSTEMS (COMP SCI EMPH)' then major_group = 5;  
	else if Major = 'MANAGEMENT INFO SYSTEMS (CONCT)' then major_group = 5;  
	else if Major = 'MANAGEMENT INFORMATION SYS' then major_group = 5;  
	else if Major = 'MANAGEMENT INFORMATION SYSTEMS' then major_group = 5; 
	else if Major = 'HRD - TRAINING AND DEVELOPMENT' then major_group = 5; 
	else if Major = 'MAJOR IN ORGANIZATIONAL BEHAVIOR' then major_group = 5;
	else if Major = 'HOUSING, INT DES & RES MGT' then major_group = 5;
	else if Major = 'DESIGN AND MERCHANDISING' then major_group = 5;
	else if Major = 'DESIGN, HOUSING AND MERCHANDISING' then major_group = 5;
	else if Major = 'INFO & OP MNGT-MIS' then major_group = 5;       
	else if Major = 'MGMT INFO SYSTEMS BS' then major_group = 5;             
	else if Major = 'MGMT INFORMATION SYS - BBA' then major_group = 5;             
	else if Major = 'MGMT INFORMATION SYSTEMS' then major_group = 5;             
	else if Major = 'MGMT INFORMATION SYSTM' then major_group = 5;             
	else if Major = 'MGT INFORMATION SYS' then major_group = 5;  
	else if Major = 'TECH MANAGEME' then major_group = 5; 
	else if Major = 'ORGANIZATION & MGMT CONCENT' then major_group = 5; 
	else if Major = 'INDUSTRIAL MANAGEMENT (GRAPHIC COMMUNICATIONS MANAGEMENT OPTION)' then major_group = 5;  
	else if Major = 'PACKAGING' then major_group = 5;             
	else if Major = 'PACKAGING SCIENCE' then major_group = 5; 
	else if Major = 'PAYROLL CLERK' then major_group = 5; 
	else if Major = 'MIS' then major_group = 5;
	else if Major = 'MASTER OF INTL MGMT' then major_group = 5;
	else if Major = 'AAS.MGMT' then major_group = 5;
	else if Major = 'ACC' then major_group = 5;
        else if Major = 'BOOKKEEPING' then major_group = 5;
        else if Major = 'BS STRENGTH BASE MGMT MAJOR' then major_group = 5;
        else if Major = 'BSOL ORGANIZATIONAL LEADERSHIP' then major_group = 5;
        else if Major = "CEGT/CONS.MGMT.OPT" then major_group = 5;
        else if Major = "COMMERCE" then major_group = 5;
        else if Major = "CONCENTRATION IN STRATEGY, EXECUTION AND VALUATION" then major_group = 5;
        else if Major = "CONCENTRATION IN TAXATION" then major_group = 5;
        else if Major = "CORPORATE" then major_group = 5;
        else if Major = "DECISION SCI & MGMT INFO SYST" then major_group = 5;
        else if Major = "ELECTRONIC COMMERCE" then major_group = 5;
        else if Major = "ENTERPRISE RESOURCES PLANNING" then major_group = 5;
        else if Major = "ENTERPRISE VIRTUALIZATION" then major_group = 5;
        else if Major = "ENTREPRENEURIAL LEADERSHIP" then major_group = 5;
        else if Major = "ENTREPRENEURSHIP" then major_group = 5;
        else if Major = "EVENTS PLAN'G/MEETING MGT CERT" then major_group = 5;
        else if Major = "EXECUTIVE ASSISTANT" then major_group = 5;
        else if Major = "FASH BUYING AND MERCHANDISING" then major_group = 5;
        else if Major = "FIN" then major_group = 5;
        else if Major = "FIN REPORTING & ATTESTATION" then major_group = 5;
        else if Major = "FOOD & BEV OPER MGT" then major_group = 5;
        else if Major = "GOLF COURSE OPERATIONS" then major_group = 5;
        else if Major = "GRADUATE TAXATION" then major_group = 5;
        else if Major = "HUMAN RSRC/INDUS REL M A" then major_group = 5;
        else if Major = "HUMN RESOURCE DEV" then major_group = 5;
        else if Major = "INCO-ORGANIZATION COMM." then major_group = 5;
        else if Major = "INVESTMENT SCIENCE & PORTFOLIO MGMT" then major_group = 5;
        else if Major = "INVESTMENTS MAJOR" then major_group = 5;
        else if Major = "MANAGERIAL ARTS AND LEADERSHIP" then major_group = 5;
        else if Major = "MASTER ORGANIZATIONAL LEADERS" then major_group = 5;
        else if Major = "MGMT & ORGANIZ DEVELOPMT" then major_group = 5;
        else if Major = "MGMT & ORGNTL LEADERSHIP" then major_group = 5;
        else if Major = "MGMT (MRKTG)" then major_group = 5;
        else if Major = "MGMT INFORMATION SCIENCES" then major_group = 5;
        else if Major = "MKTG CAREERS-CUSTOMER SERV REP" then major_group = 5;
        else if Major = "MORTGAGE BROKER" then major_group = 5;
        else if Major = "MPM MASTER OF PROJECT MGMT " then major_group = 5;
        else if Major = "NETWORKING SPECIALIST" then major_group = 5;
        else if Major = "OPERATIONS MGMT." then major_group = 5;
        else if Major = "ORG DEVELOPMENT & LEADERSHIP" then major_group = 5;
        else if Major = "ORGANIZATION DEVELOPMENT" then major_group = 5;
        else if Major = "ORGANIZATIONAL BEHAVIOR" then major_group = 5;
        else if Major = "ORGANIZATIONAL LEADERSHIP - MA" then major_group = 5;
        else if Major = "ORGANIZATIONAL LEADERSHIP MAJOR" then major_group = 5;
        else if Major = "ORGANIZATIONAL LEADERSHIP-ACCELERATED" then major_group = 5;
        else if Major = "ORGANIZATIONAL LEADERSHP" then major_group = 5;
        else if Major = "ORGANIZATIONAL MGMT" then major_group = 5;
        else if Major = "ORGANIZATIONAL MGT" then major_group = 5;
        else if Major = "ORGANIZATIONAL SYSTEMS" then major_group = 5;
        else if Major = "PRCRMNT/ACQUSTN MNGMENT" then major_group = 5;
        else if Major = "QUALITY" then major_group = 5;
        else if Major = "QUALITY ASSURANCE/REGULATORY AFFAIRS" then major_group = 5;
        else if Major = "RISK MGT + INSURANCE" then major_group = 5;
        else if Major = "SAFETY IN ORG LDRSP & SPV" then major_group = 5;
        else if Major = "SAFETY STUDIES" then major_group = 5;
        else if Major = "SAFETY/SECURITY/EMER MGT" then major_group = 5;
        else if Major = "SECRETARIAL" then major_group = 5;
        else if Major = "STRATEGIC MGMT CONCENTRATION" then major_group = 5;
        else if Major = "STRATEGY AND LEADERSHIP" then major_group = 5;
        else if Major = "SUPERVISION-CER" then major_group = 5;
        else if Major = "SUPERVISOR/MANAGER SPECIALIST" then major_group = 5;
        else if Major = "TAXATION (EXECUTIVE)" then major_group = 5;
        else if Major = "TEAM LEADERSHIP" then major_group = 5;
        else if Major = "BBA ENROLLMENT - 1 CONCENTRATION-08" then major_group = 5;
        else if Major = "BBA ENROLLMENT - 1 CONCENTRATION-09" then major_group = 5;
        else if Major = "MAPA/MAM DUAL DEGREE" then major_group = 5;
        else if Major = "MIL BSBA ENROLLMENT - 1 CONCENTRATION - 07" then major_group = 5;
        else if Major = "MIL BSBA ENROLLMENT - 1 CONCENTRATION-06" then major_group = 5;
        else if Major = "MKT" then major_group = 5;
        else if Major = "OPERATIONS RESEARCH-M" then major_group = 5;
        else if Major = "PROMOTION METHODS-CER" then major_group = 5;
        else if Major = "REAL ESTATE APPRAISAL" then major_group = 5;
        else if Major = "REAL ESTATE DEVELOPMENT" then major_group = 5;
        else if Major = "REAL ESTATE SALES" then major_group = 5;
        else if Major = "REAL ESTATE STUDIES" then major_group = 5;

        
/*  Communications and journalism */
	else if Major = 'MAGAZINE' then major_group = 6; 
	else if Major = 'PUBLIC RELATIONS' then major_group = 6; 
	else if Major = 'JOUR:MAGAZINE' then major_group = 6; 
	else if Major = 'JOUR:PUBLIC RELATIONS' then major_group = 6; 
	else if Major = 'CAD SPECIALIST' then major_group = 6;  
	else if Major = 'WRITING AND PUBLISHING' then major_group = 6;
	else if Major = 'COMMMUNICATION ARTS' then major_group = 6; 
	else if Major = 'B A - COMMUN-PUBLIC RELATIONS CONC' then major_group = 6;  
	else if Major = 'HUMAN RELATIONS & COMMUN' then major_group = 6; 
	else if Major = 'SPCH-ORG LEADERSHIP' then major_group = 6;  
	else if Major = 'COMM STUDIES BA-GEN EMPH-TRACK' then major_group = 6;       
	else if Major = 'COMM STUDIES' then major_group = 6;       
	else if Major = 'COMM STUDIES - INTERDISCIPLNRY' then major_group = 6;    
	else if Major = 'A CMM (COM MGT)' then major_group = 6;    
        else if Major = "COMM SCIENCES AND DISORDERS" then major_group = 6;
        else if Major = "CORPORATE AND PUBLIC COMM" then major_group = 6;
        else if Major = "INTERCULTURAL & INT'L COMM" then major_group = 6;
        else if Major = "INTERCULTURAL RELATIONS" then major_group = 6;
        else if Major = "INTERPERSONAL & ORGANIZ COMM" then major_group = 6;
        else if Major = "INTERPERSONAL & PUBLIC COMM" then major_group = 6;
        else if Major = "L/A*COM STDS*INTERPER RELATION" then major_group = 6;
        else if Major = "MASS COMM/RADIO-TV" then major_group = 6;
        else if Major = "NEWSPAPER" then major_group = 6;
        else if Major = "SCREENWRITING" then major_group = 6;
        else if Major = "DLVE-SLP" then major_group = 6;
        else if Major = "LEADERSHIP" then major_group = 6;
        else if Major = "LEADERSHIP STUDIES" then major_group = 6;
        else if Major = "MA, LEADERSHIP STUDIES" then major_group = 6;


/* Communications technologies / technicians */
	else if Major = 'RECORDING INDUSTRY' then major_group = 7;     
	else if Major = 'MASS COMM: DESKTOP PUB/GRAPHIC' then major_group = 7; 
	else if Major = 'ENTERTAINMENT TECH' then major_group = 7;     
	else if Major = 'ELECTRONIC PUBLISHING CERT' then major_group = 7; 
  	else if Major = 'DIGITAL IMAGE/PREPRESS TECH' then major_group = 7;  
  	else if Major = 'DIGITAL PRODUCTION ARTIST' then major_group = 7;  
  	else if Major = 'DIGITAL PRODUCTION ASSISTANT' then major_group = 7; 
	else if Major = 'PRINTING TECHNOLOGY' then major_group = 7;             
	else if Major = 'PRINTER' then major_group = 7; 
	else if Major = 'GRAPHIC ARTS AND IMAGING TECHNOLOGY TEC' then major_group = 7;  
	else if Major = 'GRAPHICS TECH-DESIGN OPT' then major_group = 7;     
        else if Major = 'GRAPHIC COMM' then major_group = 7;
        else if Major = 'VIDEO PRODUCTION SPECIALIST' then major_group = 7;

/*  Computer and information systems */
  	else if Major = 'CIS - NETWORKING' then major_group = 8;  
  	else if Major = 'CIS/PROGRAMMING' then major_group = 8;  
  	else if Major = 'CISCO CERTIFIED NETWORK ASSOCIATE' then major_group = 8;  
  	else if Major = 'CISCO CERTIFIED NETWORK CERTIFICATE' then major_group = 8;  
  	else if Major = 'CMPTR INFO SYS BS' then major_group = 8;  
  	else if Major = 'COMP + INFO SCI' then major_group = 8; 
 	else if Major = 'COMPSCIENCEINFOSYSTEMSSOFTWARE' then major_group = 8;  
  	else if Major = 'COMPTR INF SCI SOFTWR (BS)    )' then major_group = 8;  
  	else if Major = 'COMPUTING & MANGMT' then major_group = 8;  
  	else if Major = 'CYBERNETICS' then major_group = 8;  
  	else if Major = 'CYTOTECHNOLOGY' then major_group = 8; 
	else if Major = 'NETWORK SUPPORT AND ADMINISTRATION' then major_group = 8; 
	else if Major = 'NETWORKADMINISTRATORCERTIFICAT' then major_group = 8;
	else if Major = 'WEB SITE DEVELOPMENT' then major_group = 8;  
 	else if Major = 'IT FUNDAMENTALS' then major_group = 8;  
 	else if Major = 'ELT CISCO OPTION' then major_group = 8;
  	else if Major = 'DATA ENTRY I' then major_group = 8;  
  	else if Major = 'DATA PROCESSING' then major_group = 8;  
  	else if Major = 'DATA WAREHOUSING' then major_group = 8; 
	else if Major = 'NETWORK SUPPORT TECH' then major_group = 8;  
	else if Major = 'NETWORKING SERVICES TECHNOLOGY-MICROSOFT' then major_group = 8; 
	else if Major = 'DECISION SCIENCES' then major_group = 8; 
	else if Major = 'INFO SYS & DEC SCIENCES' then major_group = 8;             
	else if Major = 'INFO SYSTS & DECISION SCI' then major_group = 8;             
	else if Major = 'INFORMATICS' then major_group = 8;             
	else if Major = 'INFORMATION AND DECISION SYSTEMS' then major_group = 8;             
	else if Major = 'INFORMATION PROCESSING' then major_group = 8;             
	else if Major = 'INFORMATION SCIENCE' then major_group = 8;             
	else if Major = 'INFORMATION SECURITY & ASSURANCE' then major_group = 8;             
	else if Major = 'INFORMATION SYSTEM MGT.' then major_group = 8;             
	else if Major = 'INFORMATION SYSTEMS' then major_group = 8;             
	else if Major = 'INFORMATION SYSTEMS & TECHNOLOGY' then major_group = 8;             
	else if Major = 'INFORMATION SYSTEMS, CONC DEGR' then major_group = 8;             
	else if Major = 'INFORMATION TECHNOLOGY' then major_group = 8;             
	else if Major = 'MAJOR IN INFORMATION SYSTEMS' then major_group = 8;      
  	else if Major = 'BACHELOR OF SCIENCE IN INFORMATION TECHNOLOGY' then major_group = 8;   
	else if Major = 'APPLIED INFORMATION TECHNOLOGY' then major_group = 8;    
	else if Major = 'WORD PROCESSING' then major_group = 8;
	else if Major = 'SYMBOLIC SYSTEMS (BS)' then major_group = 8;  
   	else if Major = 'COMP GRAPHICS TECH' then major_group = 8;  
  	else if Major = 'COMP INFO SYS/APP DEV (COMP)' then major_group = 8;  
  	else if Major = 'COMP INFO SYS/OBJ ORIE (COMP)' then major_group = 8;  
 	else if Major = 'TECHNOLOGY' then major_group = 8;  
	else if Major = 'SYSTEMS ANALYSIS' then major_group = 8;   
	else if Major = 'OPERATIONS & INFO TECHNOLOGY' then major_group = 8; 
	else if Major = 'COMPUTER NETWORK ADMINISTRATION' then major_group = 8;
	else if Major = 'COMPUTER HARDWARE/TELECOMMUNIC' then major_group = 8;
	else if Major = 'COMPUTER NETWORKING/TELECOMMUNIC' then major_group = 8;
	else if Major = 'COMPUTER NETWORKING/TELECOMMUNICATIONS' then major_group = 8;
	else if Major = 'TELECOMM SYSTEMS' then major_group = 8;
	else if Major = 'TELECOMMUNICATION' then major_group = 8;
	else if Major = 'TELECOMMUNICATIONS' then major_group = 8;
	else if Major = 'TELECOMMUNICATIONS NETWORKING' then major_group = 8;
	else if Major = 'A+' then major_group = 8;
	else if Major = 'A+ AND NETWORK+ CERT. PREP' then major_group = 8;
        else if Major = 'ASSOCIATE IN APPLIED SCIENCE DEGREE IN INFORMATION SYSTEMS SECURITY' then major_group = 8;
        else if Major = 'BS COMP INFO SYST NET MAJOR' then major_group = 8;
        else if Major = 'CAS/OS: WDD: WEB ASSISTANT I' then major_group = 8;
        else if Major = 'CIS-PROGRAMMER/ANALYST' then major_group = 8;
        else if Major = 'CIS/WEB DEVELOPMENT' then major_group = 8;
        else if Major = 'CIS: DATABASE DESIGN AND SQL' then major_group = 8;
        else if Major = 'CIS: ORACLE AND SQL' then major_group = 8;
        else if Major = 'CISCO NETWORKING' then major_group = 8;
        else if Major = 'CISCO SUPPORT' then major_group = 8;
        else if Major = 'CIT FUNDAMENTALS' then major_group = 8;
        else if Major = 'CMPTR INTGRTD MFG OP' then major_group = 8;
        else if Major = 'COMP INFO SCIENCE' then major_group = 8;
        else if Major = 'COMP INFO SYS' then major_group = 8;
        else if Major = 'COMP INFO SYSTEMS' then major_group = 8;
        else if Major = 'COMP INFORM SYSTEMS' then major_group = 8;
        else if Major = 'COMP NET & INFO SECURITY' then major_group = 8;
        else if Major = 'COMP NETWORK ENG TEC' then major_group = 8;
        else if Major = 'COMP PRGM/NETWORKING CONC' then major_group = 8;
        else if Major = 'COMP PROG/ANALYST' then major_group = 8;
        else if Major = 'COMP/NETWRK INFO SYS SEC-AAT' then major_group = 8;
        else if Major = 'COMPUTING & SOFTWARE SYSTEMS' then major_group = 8;
        else if Major = 'CS SOFTWARE DEV & TESTING' then major_group = 8;
        else if Major = 'CS-INFORMATION SYSTEMS APPL' then major_group = 8;
        else if Major = 'CS-INFORMATION SYSTEMS MGT' then major_group = 8;
        else if Major = 'CSP/ELECTRONICS PRODUCTION TEC' then major_group = 8;
        else if Major = 'CTS SENIOR SYSTEMS MANAGER' then major_group = 8;
        else if Major = 'CYBERSECURITY' then major_group = 8;
        else if Major = 'DATA ENTRY CLERK' then major_group = 8;
        else if Major = 'DATA ENTRY OPERATIONS' then major_group = 8;
        else if Major = 'DATA ENTRY OPERATOR' then major_group = 8;
        else if Major = 'DIGITAL IMAGING AND DESIGN' then major_group = 8;
        else if Major = 'EDITING' then major_group = 8;
        else if Major = 'ELEC ENG (SIGNAL & IMAGE PROC)' then major_group = 8;
        else if Major = 'ELECTRONICS' then major_group = 8;
        else if Major = 'EST CISCO CERTIFICATION' then major_group = 8;
        else if Major = 'FOUNDATIONS OF INFORMATION SYS' then major_group = 8;
        else if Major = 'GAME & SIMULATION PROGRAMMING' then major_group = 8;
        else if Major = 'HIM CODING OPTION' then major_group = 8;
        else if Major = 'HUMAN COMP INTERACTION MS' then major_group = 8;
        else if Major = 'INDUST MGMT/MGMT INFO SYST' then major_group = 8;
        else if Major = 'INFO ASSURANCE AND SECURITY' then major_group = 8;
        else if Major = 'INFO NET SECURITY SPECIALIST' then major_group = 8;
        else if Major = 'INFORMATION ASSURANCE' then major_group = 8;
        else if Major = 'INFORMATION ASSURANCE (NATIONAL SECURITY AGENCY)' then major_group = 8;
        else if Major = 'INFORMATION STUDIES' then major_group = 8;
        else if Major = 'INFORMATION SYSTEMS MANG' then major_group = 8;
        else if Major = 'INFORMATION SYSTEMS MGMT' then major_group = 8;
        else if Major = 'INFORMATION SYSTEMS-BS' then major_group = 8;
        else if Major = 'IT - NETWORK SPECIALIST' then major_group = 8;
        else if Major = 'IT PROJECT MGMT' then major_group = 8;
        else if Major = 'LEAN-SIX SIGMA GREEN BELT' then major_group = 8;
        else if Major = 'LINEAR ELECTRONICS' then major_group = 8;
        else if Major = 'MAJOR: COMPUTR TEC COMMERCIAL-PURDUE' then major_group = 8;
        else if Major = 'MASTER OF INFORMATION SYSTEMS' then major_group = 8;
        else if Major = 'MGT INFO SYSTEMS' then major_group = 8;
        else if Major = 'MICROCOMP. APPLICATIONS' then major_group = 8;
        else if Major = 'MICROSOFT EXCEL APPL. PROFESS' then major_group = 8;
        else if Major = 'MICROSOFT WORD APPL PROF' then major_group = 8;
        else if Major = 'MNGT INFORMATION SYSTEMS' then major_group = 8;
        else if Major = 'MODELING AND SIMULATION' then major_group = 8;
        else if Major = 'MSN - INFORMATICS SPECIALIST' then major_group = 8;
        else if Major = 'NT - WINDOWS 2003 AAS STD.' then major_group = 8;
        else if Major = 'PC INFORMATION SPECIALIST' then major_group = 8;
        else if Major = 'PC SUPPORT SPECIALIST' then major_group = 8;
        else if Major = 'PERSONAL COMP SPECIALIST' then major_group = 8;
        else if Major = 'PHOTOGRAPHIC IMAGING' then major_group = 8;
        else if Major = 'PRINTING & DESKTOP PUBLISHING' then major_group = 8;
        else if Major = 'PRODUCTIVITY SOFTWARE SPCIALST' then major_group = 8;
        else if Major = 'PROGRAMMABLE LOGIC CONTROLLERS' then major_group = 8;
        else if Major = 'SOFTWARE APP PRFESNL' then major_group = 8;
        else if Major = 'SPATIAL INFORMATION PROCESSING' then major_group = 8;
        else if Major = 'SURVIVABILITY AND INFORMATION ASSURANCE' then major_group = 8;
        else if Major = 'WEB CAREERS-WEB PROGRAMMING' then major_group = 8;
        else if Major = 'WEB DESIGN' then major_group = 8;
        else if Major = 'WEB DESIGNER' then major_group = 8;
        else if Major = 'WEB PUBLISHING+DESIGN CERT' then major_group = 8;
        else if Major = 'WEB SYSTEMS' then major_group = 8;
        else if Major = 'WEB USER EXPERIENCE' then major_group = 8;
        else if Major = 'WEBMASTER CERTIFICATION' then major_group = 8;
        else if Major = 'WEBSITE DEVELOP & DESIGN' then major_group = 8;
        else if Major = 'ITEC' then major_group = 8;


        

/* Construction trades */
	else if Major = 'ELECTRICAL TRADES' then major_group = 9;
	else if Major = 'ELECTRICAL TRADES TECHNOLOGY' then major_group = 9;
	else if Major = 'RESIDENTIAL WIRING' then major_group = 9; 
	else if Major = 'PLUMBING DIPLOMA' then major_group = 9; 
	else if Major = 'CARPENTRY APPRENTICESHIP' then major_group = 9;  
  	else if Major = 'BRICKLAYER APPRENTICE' then major_group = 9;  
  	else if Major = 'BRICKLAYER HELPER' then major_group = 9;
	else if Major = 'APP-ELECTRICIAN' then major_group = 9;   
	else if Major = 'BUILDING UTILITIES MECHANIC' then major_group = 9; 
        else if Major = 'APPRENTICE-DRYWALL/LATHER' then major_group = 9;
        else if Major = 'CABINETMAKING AND MILLWORK' then major_group = 9;
        else if Major = 'CARPENTRY' then major_group = 9;
        else if Major = 'CNC TOOL & MOLDMAKER' then major_group = 9;
        else if Major = 'CNC TOOL ROOM MACHINIST' then major_group = 9;
        else if Major = 'COMMERCIAL WIRING' then major_group = 9;
        else if Major = 'ELECTRICAL CONTRACTORS' then major_group = 9;
        else if Major = 'LANDSCAPE CONTRACTING(AS)' then major_group = 9;
        else if Major = 'MANUFACTURING' then major_group = 9;
        else if Major = 'MANUFACTURING MAINTENANCE FUND' then major_group = 9;
        else if Major = 'MASONRY (DIPLOMA)' then major_group = 9;
        else if Major = 'PIKE CONTRACT MAJOR OR MINOR' then major_group = 9;
        else if Major = 'PIPEFITTING APPRENTICESHIP BUILDING TRADES' then major_group = 9;
        else if Major = 'STEAMFITTING APPRENTICE' then major_group = 9;

/*  Criminal justice */
	else if Major = 'CR JUST MA: DEVIANC' then major_group = 10;
	else if Major = 'CR JUST MA: POL ADM' then major_group = 10;
	else if Major = 'BS-CJFSS-CRT,PRB,COR,PAR&JUVN' then major_group = 10; 
        else if Major = 'MAJOR IN CRIMINAL JUSTICE ADMINISTRATION' then major_group = 10;  
        else if Major = 'POLICE ADMIN' then major_group = 10;
        else if Major = 'CRIMINAL JUSTICE ADMIN BA' then major_group = 10;
        else if Major = 'CRIMINAL JUSTICE ADMINISTRATION' then major_group = 10;
        else if Major = 'CRIMINAL JUSTICE ADMINISTRATION    CRJA      21051' then major_group = 10;  
        else if Major = 'ADVANCED OFFICER TRAINING' then major_group = 10;  
        else if Major = 'APPLIED FORENSIC SPECIALIZATION' then major_group = 10;
        else if Major = 'DIGITAL FORENSICS' then major_group = 10;
        else if Major = 'FINGERPRINT CLASSIFICATION' then major_group = 10;
        else if Major = 'FORENS' then major_group = 10;
        else if Major = 'FORENSIC SCIENCE' then major_group = 10;
        else if Major = 'MS-FORENSIC ENTOMOLOGY' then major_group = 10;
        else if Major = 'PENAL CODE 832 POWERS OF ARREST' then major_group = 10;
        else if Major = 'CRMJ' then major_group = 10;
        
/*  Economics  */
       else if Major = 'ECON W/ FINANCE APPL - BS' then major_group = 11;
       else if Major = "INT'L ECONOMICS & FINANCE" then major_group = 11;
       else if Major = 'ECONOMICS/FINANCE' then major_group = 11;
       else if Major = 'ECONOMICS AND FINANCE' then major_group = 11;
       else if Major = 'ECONOMICS (BUSINESS)' then major_group = 11;
       else if Major = 'ECONOMICS AND BUSINESS' then major_group = 11;
       else if Major = 'ECONOMICS & MANAGEMENT SCIENCE' then major_group = 11;

/* Education and Library Science*/
	else if Major = 'ADOLESC ED 7-12 SOC STUDIES BS' then major_group = 12;
	else if Major = 'BILINGUAL,MULTICULT.ED./TESOL' then major_group = 12;
	else if Major = 'BSED ELU/READING' then major_group = 12;
	else if Major = 'CH ED TCH LIBAR A(TRANSB) MSED' then major_group = 12;
	else if Major = 'CLASSROOM TECHNOLOGY' then major_group = 12;
	else if Major = 'ERLY CHLD/CHLD CARE' then major_group = 12;
	else if Major = 'LIT LITERACY-BIRTH-GRADE 6' then major_group = 12;
	else if Major = 'LITERACY 5-12' then major_group = 12;
	else if Major = 'SOCIAL STUDIES 7-12' then major_group = 12;	
	else if Major = 'SOCIAL STUDIES (SEC SCHL TCHG)' then major_group = 12;
	else if Major = 'SPEC & ELM ED (BSED)' then major_group = 12;
	else if Major = 'SPEC ED: LEARNING DISABILITY' then major_group = 12;
	else if Major = 'SPECIAL E-EMOTIONAL IMPAIRMENT' then major_group = 12;
	else if Major = 'SPECIAL ED: LEARNING DISABILITIES' then major_group = 12;
	else if Major = 'TESOL' then major_group = 12;  
	else if Major = 'TCHRS OF MENTALLY IMPAIRED' then major_group = 12;  
	else if Major = 'SPECIAL ED: LEARNING DISABILITIES   LRE T 0808' then major_group = 12;  
	else if Major = 'PHYSICAL SCIENCE ED 7-12' then major_group = 12;  
	else if Major = 'P/S*MENT/PHYS HAND*SPECIAL ED' then major_group = 12;  
	else if Major = 'MIDDLE GRD ED: S/SS    5-9 (T)' then major_group = 12;  
	else if Major = 'MASTER LITERACY ED (K-12)' then major_group = 12;  
	else if Major = 'S ED MATHEMATICS BS' then major_group = 12;  
	else if Major = 'ENGLISH ED' then major_group = 12;  
	else if Major = 'ENGLISH {EARLY ADOLESCENCE-ADOLESCENCE}' then major_group = 12;  
	else if Major = 'READING' then major_group = 12;     
	else if Major = 'READING SPECIALIST' then major_group = 12;   
	else if Major = 'ED ADMIN' then major_group = 12;  
	else if Major = 'ED ORGANIZATION AND LEADERSHIP' then major_group = 12; 
	else if Major = 'EPD:READING' then major_group = 12; 
	else if Major = 'GUIDANCE AND COUNSELING' then major_group = 12;  
	else if Major = 'COUNSELING AND GUIDANCE SERVICES' then major_group = 12; 
	else if Major = 'ED ORGANIZATION AND LEADERSHIP' then major_group = 12;
	else if Major = 'INSTRUCTIONAL IMPROVEMENT' then major_group = 12;             
	else if Major = 'INSTRUCTIONAL LEADERSHIP' then major_group = 12;             
	else if Major = 'INSTRUCTIONAL TECHNOLOGY' then major_group = 12;  
	else if Major = 'INTENSIVE SPEC. NEED' then major_group = 12;
	else if Major = 'COACHING' then major_group = 12;
	else if Major = 'PROFESSIONAL COUNSELING' then major_group = 12; 
	else if Major = 'EED' then major_group = 12;    
	else if Major = 'GRAD SPE-MILD LRNG HC' then major_group = 12;         
	else if Major = 'LSC LIB & INFO SCI' then major_group = 12; 
        else if Major = 'MA-URBAN ED-ADMN & SUPERVISION' then major_group = 12;  
        else if Major = 'ELEM ED(ENGLISH/SECOND LANG)' then major_group = 12;
        else if Major = 'HOME ECONOMICS EDUCATION' then major_group = 12;
        else if Major = 'EDUCATIONAL ADMIN' then major_group = 12;
        else if Major = 'EDUCATION ADMINISTRATION' then major_group = 12;
        else if Major = 'EDUCATION:EDUCATIONAL ADMIN' then major_group = 12;
        else if Major = 'EDUCATION:PHYSICAL ED ADMIN' then major_group = 12;
        else if Major = 'EDUCATIONAL ADMINISTRATN' then major_group = 12;
        else if Major = 'EDUCATIONAL ADMINISTRATION' then major_group = 12;
        else if Major = 'EDUCATIONAL ADMINISTRATION--K-12 LEADERSHIP' then major_group = 12;
        else if Major = 'SCHOOL ADMINISTRATION' then major_group = 12;
        else if Major = 'SCHOOL ADMINISTRATION DISTANCE TRACK' then major_group = 12;
        else if Major = 'COMMUNICATION - ELEM EDUC' then major_group = 12;
        else if Major = 'EARLY CHILDHOOD ADMINISTRATOR' then major_group = 12;
        else if Major = 'MUSIC, K-12' then major_group = 12;
        else if Major = 'AGRICULTURAL EDUCATION' then major_group = 12;
        else if Major = 'AGRICULTURAL EDUCATION - TEACHER PREPARATION OPTION' then major_group = 12;
        else if Major = 'BIOLOGY EDUCATION' then major_group = 12;
        else if Major = 'ENVIRONMENTAL EDUCATION' then major_group = 12;
        else if Major = 'LANGUAGE ARTS FIELD 7-12' then major_group = 12;
        else if Major = 'SPANISH 7-12' then major_group = 12;
	else if Major = 'LSC LIB & INFO SCI' then major_group = 12; 
        else if Major = 'AAT_EC6G' then major_group = 12;
        else if Major = 'ADOL ED LITERACY 5-12 MSED' then major_group = 12;
        else if Major = 'ADOLESCENCE ED: SOCIAL STUDIES' then major_group = 12;
        else if Major = "APPL ED PSY:READING SPECIALIST" then major_group = 12;
        else if Major = "ASSOCIATE ARTS--GEN. ED. (AA)" then major_group = 12;
        else if Major = "BSC PROFESSIONAL SECNDRY ENDRS" then major_group = 12;
        else if Major = "C&I: CLASSROOM INSTR" then major_group = 12;
        else if Major = "C&I: LITERACY" then major_group = 12;
        else if Major = "E CHLD/YOUTH DEVELOP" then major_group = 12;
        else if Major = "EARLY CHLD ED CDA PROCESS" then major_group = 12;
        else if Major = "EARLY INTERV/EARLY CHLDH SPED" then major_group = 12;
        else if Major = "ED DEVELOPMENT & STRATEGIES" then major_group = 12;
        else if Major = "ED LEAD&POL STDY-MED NT (AP)" then major_group = 12;
        else if Major = "ED LEADERSHIP BLDG-MSE" then major_group = 12;
        else if Major = "ED: DIG TCH/LRN & MS TCH CR A" then major_group = 12;
        else if Major = "FOUNDATION OF ED:EARLY CHLD BS" then major_group = 12;
        else if Major = "GRAD ED READING" then major_group = 12;
        else if Major = "INSTRUCTION AND LEARNING" then major_group = 12;
        else if Major = "INSTRUCTIONAL LEADERSHIIP" then major_group = 12;
        else if Major = "INSTRUCTIONAL LEADERSHIP PRINCIPAL ALL G" then major_group = 12;
        else if Major = "K-12 PRINCIPAL" then major_group = 12;
        else if Major = "K-8 SOCIAL STUDIES" then major_group = 12;
        else if Major = "LITERACY" then major_group = 12;
        else if Major = "LITERACY B-6" then major_group = 12;
        else if Major = "LITERACY SPECIALIST, BIRTH-6" then major_group = 12;
        else if Major = "M.A.T/SEC" then major_group = 12;
        else if Major = "MAJOR: KINDERGRTN/PRIMARY ED" then major_group = 12;
        else if Major = "MIDDLE GRADES 5-9 AREA" then major_group = 12;
        else if Major = "MILD/MODERATE HANDICAP K-6" then major_group = 12;
        else if Major = "MLSU 68 SUPERINTENDENT" then major_group = 12;
        else if Major = "MONTESSORI" then major_group = 12;
        else if Major = "PHED-GEN PHYSICAL ED K-12&6-12" then major_group = 12;
        else if Major = "PHYSICAL ED" then major_group = 12;
        else if Major = "POSTSECONDARY AND ADULT ED" then major_group = 12;
        else if Major = "PROMOTER ED & EMPLOY PROJ" then major_group = 12;
        else if Major = "READING & LITERACY B-12" then major_group = 12;
        else if Major = "READING & SPECIAL ED" then major_group = 12;
        else if Major = "SOCIAL SCIENCE (5-12)" then major_group = 12;
        else if Major = "SOCIAL SCIENCE ED SECONDARY" then major_group = 12;
        else if Major = "SPEC ED INSTRUCT SPECLST 4 12" then major_group = 12;
        else if Major = "SPEC ED MILD DISABILITIES" then major_group = 12;
        else if Major = "SPECIAL ED: LEARNING DISABIL" then major_group = 12;
        else if Major = "SPECIALIST IN MIDDLE GRADES" then major_group = 12;
        else if Major = "SPECL ED-EMOTIONALLY IMPAIRED" then major_group = 12;
        else if Major = "SUPERINTENDENT" then major_group = 12;
        else if Major = "TCHR OF HANDICAP" then major_group = 12;
        else if Major = "C&I: INT SP MILD/MOD     " then major_group = 12;
        else if Major = "EC/EEN" then major_group = 12;
        else if Major = "EDAD" then major_group = 12;
        else if Major = "EDLD" then major_group = 12;
        else if Major = "EDS ED LDRSHIP:SPRNTNDNT" then major_group = 12;
        else if Major = "ELE-BS" then major_group = 12;
        else if Major = "MAT" then major_group = 12;
        else if Major = "POST MA CERT EDCTNL LEADERSHIP" then major_group = 12;
        else if Major = "SPE " then major_group = 12;
        else if Major = "TCH URB ADL DIS ALT CRT M.S.E." then major_group = 12;
        else if Major = "-EC-4(EXCPT EC SPEC),4-8,EC-12-" then major_group = 12;
        else if Major = "8-12 GRADE LEVELS" then major_group = 12;      

/*  Engineering */
	else if Major = 'ENGINEERING MANAGEMENT              TGI' then major_group = 13;  
	else if Major = 'INDUSTRIAL ENGINEERING AND MANAGEMENT' then major_group = 13;  
  	else if Major = 'ELEC ENG (COMMUNIC THRY & SYS)' then major_group = 13;
  	else if Major = 'ELECTRICAL AND ELECTRONICS ENG' then major_group = 13; 
  	else if Major = 'MECHANICAL ENG' then major_group = 13;  
  	else if Major = 'COMPOSITE MATERIAL ENG/MECHANICAL' then major_group = 13;  
	else if Major = 'SURVEYING ENGINEERING' then major_group = 13;  
	else if Major = 'INDUSTRIAL AND MANUFACTURING E' then major_group = 13; 
	else if Major = 'OPERATIONS RESEARCH' then major_group = 13;
	else if Major = 'MANUFACTURING SYSTEMS' then major_group = 13;       
	else if Major = 'OPERATIONS' then major_group = 13;  
	else if Major = 'INDUSTRIAL DISTRIBUTION' then major_group = 13;  
	else if Major = 'INDUSTRIAL SAFETY' then major_group = 13;  
	else if Major = 'INDUSTRIAL SCIENCES' then major_group = 13;  
	else if Major = 'PAPER SCIENCE' then major_group = 13; 
        else if Major = 'MECHANICAL ENGIN (BSE)' then major_group = 13; 
        else if Major = 'MECHANICAL ENGINEER' then major_group = 13; 
        else if Major = 'BIOENGINEERING' then major_group = 13;
        else if Major = 'BIOMEDICAL ENGINEERING' then major_group = 13;
        else if Major = 'BIOMED ENGR' then major_group = 13;
        else if Major = 'BIOSYSTEMS ENGINEERING' then major_group = 13;
        else if Major = 'CIVIL & ENVIR ENGR (BS)' then major_group = 13;
        else if Major = 'CIVIL & ENVIR ENGR (MS)' then major_group = 13;
        else if Major = 'COMPUTER ENGINEERING' then major_group = 13;
        else if Major = 'COMPUTER ENGINEERING - CISE' then major_group = 13;
        else if Major = 'COMPUTER ENGINEERING - ELECTRICAL ENGINEERING' then major_group = 13;
        else if Major = 'COMPUTER ENGINEERING M S' then major_group = 13;
        else if Major = 'COMPUTER ENGINEERING-CPSC' then major_group = 13;
        else if Major = 'COMPUTER ENGINEERING-ECEN' then major_group = 13;
        else if Major = 'COMPUTER HARDWARE ENGINEERING' then major_group = 13;
        else if Major = 'COMPUTER SCIENCE ENGINEERING' then major_group = 13;
        else if Major = 'ELEC AND COMPUTER ENGINEERING' then major_group = 13;
        else if Major = 'ELECTRICAL & COMPUTER ENG' then major_group = 13;
        else if Major = 'ELECTRICAL AND COMPUTER ENGINEERING' then major_group = 13;
        else if Major = 'ELECTRICAL&COMPUTER ENGINEER' then major_group = 13;
        else if Major = 'GENERAL CIVIL ENGINEER OPT' then major_group = 13;
        else if Major = 'ENVIRONMENTAL ENGINEERING' then major_group = 13;
        else if Major = 'ENVIRONMENTAL ENGINEERING SCIENCES' then major_group = 13;
        else if Major = 'MTLRGY & MAT SCI' then major_group = 13;
        else if Major = 'APPLIED PHYSICS/ELECTRICAL ENG' then major_group = 13;
        else if Major = 'INDUSTRIAL & SYSTEMS ENGINEER' then major_group = 13;
        else if Major = 'MECH ENG' then major_group = 13;
        else if Major = 'MECH ENGG/MATERIALS SCI' then major_group = 13;
        else if Major = 'N MECHANICL ENGINEER' then major_group = 13;
        else if Major = 'ROBOTICS' then major_group = 13;
        else if Major = 'SYSTEMS ENG-MS NON THESIS ' then major_group = 13;
        else if Major = 'CPEG' then major_group = 13;
        else if Major = 'EMGT' then major_group = 13;
       
/*  Engineering technologies / trades */
	else if Major = 'ELEC/ELECTRONICS TECH:  COMMERICAL WIRING' then major_group = 14; 
	else if Major = 'VEHICLE DESIGN TECHNOLOGY' then major_group = 14;   
	else if Major = 'VEHICLE & EQUIPMENT OPER' then major_group = 14;   
	else if Major = 'SURVEYING CAD TECHNOLOGY' then major_group = 14;   
	else if Major = 'ROBOTICS TECHNICIAN' then major_group = 14;   
  	else if Major = 'MECHANICAL ENG TECHNOLOGY' then major_group = 14;  
  	else if Major = 'ELECTRICAL POWER GENERATION' then major_group = 14;  
  	else if Major = 'ELECTRICAL TECHNOLOGY' then major_group = 14;  
  	else if Major = 'ELECTRICAL/ELECTRONICS' then major_group = 14;  
  	else if Major = 'ELECTROMECHANICAL TECHNOLOGY' then major_group = 14;  
  	else if Major = 'ELECTRONIC TECHNOLOGY' then major_group = 14;  
  	else if Major = 'ELECTRONICS TECHNICIAN' then major_group = 14;  
  	else if Major = 'ELECTRONICS TECHNOLOGY' then major_group = 14;  
  	else if Major = 'ELECTRONICS TECHNOLOGY AAS' then major_group = 14;  
  	else if Major = 'ENG TECH/ELECTRONICS' then major_group = 14;  
  	else if Major = 'FLIGHT TECHNOLOGY' then major_group = 14;  
	else if Major = 'MTLRGY & MAT SCI' then major_group = 14;  
	else if Major = 'SURVEYING' then major_group = 14; 
	else if Major = 'INDUSTRIAL TECH' then major_group = 14;  
	else if Major = 'INDUSTRIAL TECHNOLOGY' then major_group = 14;  
	else if Major = 'INDUSTRIAL TECHNOLOGY' then major_group = 14;  
	else if Major = 'INDUSTRIAL TECHNOLOGY (APPRNT)' then major_group = 14;   
	else if Major = 'INDUSTRIAL ARTS' then major_group = 14; 
	else if Major = 'INDUSTRIAL TECHNOLOGY               TEC   0839' then major_group = 14; 
	else if Major = 'INDUS ELECTRICITY/ELECTRONICS' then major_group = 14;  
	else if Major = 'MT01 MECHANICAL TECHNOLOGY' then major_group = 14;  
	else if Major = 'SKILLED TRADES ELECTRICAL' then major_group = 14; 
	else if Major = 'POWER PLANT TECH' then major_group = 14;  
	else if Major = 'NONDESTRUCTIVE TESTING TECHNOLOGY' then major_group = 14;  
	else if Major = 'PLASTICS TECHNOLOGY' then major_group = 14;   
	else if Major = 'TECH-INDUSTRIAL SAFETY' then major_group = 14; 
   	else if Major = 'MECHANICAL' then major_group = 14;
	else if Major = 'IND TECH' then major_group = 14;       
	else if Major = 'IND TECH/IND MGT-PLAN&DESIGN' then major_group = 14;                  
	else if Major = 'CIVIL ENGINEERING DRAFTING' then major_group = 14;  
	else if Major = 'ENGINEERING GRAPHICS TECH     039035303' then major_group = 14; 
	else if Major = 'ENGINEERING GRAPHICS TECHNOLOGY     EGT  35303' then major_group = 14; 
	else if Major = 'CAD SPECIALIST' then major_group = 14;  
        else if Major = 'INDUSTRIAL & MANAGEMENT ENGR' then major_group = 14; 
        else if Major = 'INDUSTRIAL MANAGEMENT' then major_group = 14; 
        else if Major = 'INDUSTRIAL MANAGEMENT (GRAPHIC COMMUNICATIONS MANAGEMENT OPTION)' then major_group = 14; 
        else if Major = 'COMPUTER ENGINEERING TECHNOLOGY' then major_group = 14;
        else if Major = 'COMPUTER ELECTRONICS TECHNOLOGY' then major_group = 14;
        else if Major = 'COMPUTER DESIGN & ANIMATION ENGINEERING TECHNOLOGY' then major_group = 14;
        else if Major = 'COMPUTER AIDED DRAFTING' then major_group = 14;
        else if Major = 'COMPUTER-AIDED DESIGN' then major_group = 14;
        else if Major = 'ELECTRONICS ENGINEERING TECH, COMPUTER REPAIR' then major_group = 14;
        else if Major = 'AG ENG TECH & BUS' then major_group = 14;
        else if Major = 'TELECOM. & WIRELESS TECH.' then major_group = 14;
        else if Major = 'ITD/ENGR GRAPHICS & DSGN' then major_group = 14;
        else if Major = 'AIR CONDITIONING AND ELECTRICAL ACCESSORIES' then major_group = 14;
        else if Major = 'AIR CONDITIONING, HTG & REFRIG' then major_group = 14;
        else if Major = 'ELECTRICAL APPRENTICE - 4 YEAR' then major_group = 14;
        else if Major = 'ELECTRICAL CONTROL SYSTEMS' then major_group = 14;
        else if Major = 'ELECTRICAL DISTRIBUTION SYSTEMS CERT' then major_group = 14;
        else if Major = 'ELECTRICAL OCCUPATIONS' then major_group = 14;
        else if Major = 'ELECTRICAL SYSTEMS ASSISTANT' then major_group = 14;
        else if Major = 'ELECTRICAL/ELECTRONICS DESIGN' then major_group = 14;
        else if Major = 'ELECTRICIAN' then major_group = 14;
        else if Major = 'ELECTRICIAN APPRENTICESHIP' then major_group = 14;
        else if Major = 'ELECTRICIAN DIPLOMA' then major_group = 14;
        else if Major = 'ELECTRICITY-CERT' then major_group = 14;
        else if Major = 'ELECTRO-MECHANICAL' then major_group = 14;
        else if Major = 'ENGINE' then major_group = 14;
        else if Major = 'FLUID POWER' then major_group = 14;
        else if Major = 'HEATING VENTILATION & AIR COND' then major_group = 14;
        else if Major = 'HEATING, VENT AND AIR COND' then major_group = 14;
        else if Major = 'HEATING, VENTILATION & AIR CONDITIONING 55 CR 720 HRS V3-0' then major_group = 14;
        else if Major = 'HEATING/COOLING' then major_group = 14;
        else if Major = 'HEAVY EQUIPMENT OPERATOR' then major_group = 14;
        else if Major = 'INDUSTRIAL ELECTRICIAN' then major_group = 14;
        else if Major = 'INDUSTRIAL ELECTRICITY' then major_group = 14;
        else if Major = 'INDUSTRIAL ELECTRONICS' then major_group = 14;
        else if Major = 'MOLD DESIGNER PLASTIC' then major_group = 14;
        else if Major = 'PACKAGING DESIGN' then major_group = 14;
        else if Major = 'RESIDENTIAL HEAT. VENT. & ACR' then major_group = 14;
        else if Major = 'RESIDENTIAL HEATING VENT AND AC' then major_group = 14;
        else if Major = 'SECURITY +' then major_group = 14;
        else if Major = 'SECURITY SYSTEMS' then major_group = 14;
        else if Major = 'SURFCAM' then major_group = 14;
        else if Major = 'HVAC LI 11' then major_group = 14;
        else if Major = 'TS - NNSY APPRENTICE' then major_group = 14;
        else if Major = 'APPLIED ELECTRONIC STUDIES' then major_group = 14;
        
/*  English and foreign languages and literature */
	else if Major = 'COMPARATIVE LITERATURE' then major_group = 15; 
	else if Major = 'COMPARATIVE LITERATURE (CINEMA STUDIES)' then major_group = 15;
	else if Major = 'ENGL & AM LIT' then major_group = 15; 
	else if Major = 'FRENCH' then major_group = 15; 
	else if Major = 'FRENCH BA' then major_group = 15; 
        else if Major = 'GERMAN' then major_group = 15; 
	else if Major = 'HEBREW BA' then major_group = 15; 
	else if Major = 'JAPANESE' then major_group = 15; 
	else if Major = 'KOREAN' then major_group = 15; 
	else if Major = 'MAJOR IN FRENCH' then major_group = 15; 
	else if Major = 'MAJOR IN JAPANESE' then major_group = 15; 
	else if Major = 'MAJOR: FRENCH' then major_group = 15; 
	else if Major = 'PORTUGUESE' then major_group = 15; 
	else if Major = 'RUSSIAN' then major_group = 15; 
	else if Major = 'FRENCH                              RL' then major_group = 15; 
	else if Major = 'ITALIAN MA' then major_group = 15; 
	else if Major = 'LITERATURE' then major_group = 15; 
	else if Major = 'LITERATURE, SCIENCE AND THE ARTS' then major_group = 15; 
	else if Major = 'LITERARY STUDIES' then major_group = 15;  
	else if Major = 'CREATIVE WRITING' then major_group = 15; 
	else if Major = 'CREATIVE WRITING - LITERATURE' then major_group = 15; 
	else if Major = 'LATIN' then major_group = 15; 
	else if Major = 'LINGUISTICS' then major_group = 15;  
	else if Major = 'CLASSICAL STUDIES' then major_group = 15; 
	else if Major = 'CLASSICS' then major_group = 15; 
	else if Major = 'CLASSICS                            CLS' then major_group = 15;   
	else if Major = 'INTERPRETER TRAINING' then major_group = 15;   
	else if Major = 'HUMANITIES' then major_group = 15; 
	else if Major = 'HUMANITIES AA' then major_group = 15;
	else if Major = 'P/S*INTERPRETER TRAINING' then major_group = 15;
	else if Major = 'BASIC BUSINESS SPANISH' then major_group = 15; 
	else if Major = 'SPANISH LANG & LIT W/ BUSINESS' then major_group = 15; 
	else if Major = 'ADV PROFICIENCY IN RUSSIAN CRT' then major_group = 15; 
        else if Major = 'BACHELOR OF ARTS IN FRENCH' then major_group =  15;
        else if Major = 'COMPOSITION' then major_group =  15;
        else if Major = 'ENGL-CREATIVE WRIT' then major_group =  15;
        else if Major = 'ITALIAN' then major_group =  15;
        else if Major = 'LIBERAL STUDIES: �BILINGUAL/CROSS CULTURAL' then major_group =  15;
        else if Major = "LIBERAL STUDIES:  BILINGUAL/CROSS CULTURAL" then major_group =  15;
        else if Major = 'LINGUISTICS-PHD' then major_group =  15;
        else if Major = 'LITERATURE BA' then major_group =  15;
        else if Major = 'LITERATURE MA' then major_group =  15;
        else if Major = 'LSC - LITERATURE' then major_group =  15;
        else if Major = 'MAJOR: LINGUISTICS' then major_group =  15;
        else if Major = 'MFA-POETRY CONCENTRATION' then major_group =  15;
        else if Major = 'PROFESSIONAL WRITING' then major_group =  15;
        else if Major = 'RUSSIAN BA' then major_group =  15;
        else if Major = 'WRITING' then major_group =  15;
        else if Major = 'TESL CERT - W/PRIOR STD/CEAS' then major_group =  15;
        
/* Family and consumer sciences */
	else if Major = 'MAJOR: HUMAN DEVELOPMENT' then major_group = 16;  
	else if Major = 'HUMAN DEVELOPMENT' then major_group = 16;
	else if Major = 'HUMAN DEVELOPMENT & LEARNING' then major_group = 16;
	else if Major = 'HUMAN DEVELOPMENT BA' then major_group = 16;
	else if Major = 'HUMAN DEVELOPMENT STUDIES' then major_group = 16;
	else if Major = 'BEHAVIORAL SCIENCE' then major_group = 16;
	else if Major = 'BEHAVIORAL SCIENCES' then major_group = 16;
	else if Major = 'SOCIAL & BEHAVIORAL SCIENCE' then major_group = 16;
        else if Major = 'MAJOR IN BEHAVIORAL SCIENCE' then major_group = 16;  
	else if Major = 'CONSUMER SCIENCE' then major_group = 16;  
	else if Major = 'CONSUMER STUDIES' then major_group = 16;  
	else if Major = 'HOLISTIC HUMAN DEVELOPMENT' then major_group = 16;  
	else if Major = 'FAM/CONS SCI-INT DESIGN' then major_group = 16; 
	else if Major = 'CONSUMER ECONOMICS' then major_group = 16; 
	else if Major = 'HOME ECONOMICS' then major_group = 16; 
        else if Major = 'HOME AND FAMILY / HOME ECONOMCS' then major_group = 16;
	else if Major = 'CONSUMER ECONOMICS & HOUSING' then major_group = 16;
        else if Major = 'LEADERSHIP AND CONSUMER ECONOMICS' then major_group = 16;
        else if Major = 'CHILD AND ADOLESCENT DEVELOPMENT' then major_group = 16;
        else if Major = 'CHILD AND ADOLESCENT DEVELOPMENT (YOUNG CHILD AND FAMILY)' then major_group = 16;
        else if Major = 'CHILD AND FAMILY DEV (COMP)' then major_group = 16;
        else if Major = 'CHILD AND FAMILY DEVELOPMENT' then major_group = 16;
        else if Major = 'CHILD AND FAMILY STUDIES' then major_group = 16;
        else if Major = 'CHILD DEV & FAMILY RELATIONS' then major_group = 16;
        else if Major = 'CHILD DEVEL & FAMILY SCI' then major_group = 16;
        else if Major = 'CHILD DEVELOPMENT' then major_group = 16;
        else if Major = 'CHILD DEVELOPMENT                   CD' then major_group = 16;
        else if Major = 'CHILD DEVELOPMENT & FAMILY RELATIONS' then major_group = 16;
        else if Major = 'CHILD DEVELOPMENT WITH PRE-CREDENTIAL PREPARATION' then major_group = 16;
        else if Major = 'CHILD DEVELOPMENT.' then major_group = 16;
        else if Major = 'CHILD IN SOCIETY' then major_group = 16;
        else if Major = 'CHILD LIFE' then major_group = 16;
        else if Major = 'EARLY CHILDHOOD & FAMILY STUDIES' then major_group = 16;
        else if Major = 'EARLY CHILDHOOD DEVELOPMENT' then major_group = 16;
        else if Major = 'CHILD LIFE' then major_group = 16;
        else if Major = 'CHILD LIFE' then major_group = 16;
        else if Major = 'FAMILY RELATIONS AND CHILD DEVELOPMENT' then major_group = 16;
        else if Major = 'FCS - CHILD DEVEL' then major_group = 16;
        else if Major = 'FCS/CHILD DEVELOPMENT COMP' then major_group = 16;
        else if Major = 'FCS:CHILD&FAMILY STUDIES' then major_group = 16;
        else if Major = 'HUMAN DEVELOPMENT:  CHILD DEVELOPMENT TRACK' then major_group = 16;
        else if Major = 'LIBERAL STUDIES-CHILD DEVELOP' then major_group = 16;
        else if Major = 'HEALTH AND HUMAN DEVELOPMENT' then major_group = 16;
        else if Major = 'CFCS-CHILD DEV FAMILY REL' then major_group = 16;
        else if Major = 'CHILD & FAMILY DEVELOP. (PREKINDERGARTEN)' then major_group = 16;
        else if Major = 'EARLY CHILDHOOD DEVELOPMENT AND EDUCATION' then major_group = 16;
        else if Major = 'HUMAN SERVICES (AA)' then major_group = 16;
        else if Major = "*HUMAN SERVICES (AA)" then major_group = 16;
        else if Major = 'APPL LEARN AND DEV/EARLY CHLD GR 4 BILING GEN CERT' then major_group = 16;
        else if Major = 'APPL LEARN AND DEV/EARLY CHLD GR 4 GEN CERT' then major_group = 16;
        else if Major = 'CHLD DEVELOPMENT ASSOC CERT' then major_group = 16;
        else if Major = 'CONSUMER, APPRL, AND RETAIL ST' then major_group = 16;
        else if Major = 'HUMAN DEVEL & RELATIONSHIPS' then major_group = 16;
        else if Major = 'HUMAN LEARNING' then major_group = 16;
        else if Major = 'HUMAN RELATIONS' then major_group = 16;
        else if Major = 'HUMAN SCIENCES' then major_group = 16;
        else if Major = 'HUMAN SERVICES & CONSUMER SCI' then major_group = 16;
        else if Major = 'RETAILING AND RETAIL OPERATION' then major_group = 16;
        
/*  Geography, history, political science, sociology, and social science */
	else if Major = 'GOVERNMENT' then major_group = 17;  
	else if Major = 'GOVERNMENT & POLITICS' then major_group = 17;  
	else if Major = 'HIS/SECED(US/WC;GOV)' then major_group = 17;  
	else if Major = 'POLITICS' then major_group = 17;  
	else if Major = 'POLI SCI - POLITICS & GOV' then major_group = 17;  
	else if Major = 'SOCIAL SCI' then major_group = 17;       
	else if Major = 'SOCIAL SCI (CONCENTRATION)' then major_group = 17;       
	else if Major = 'SOCIAL SCIENCE' then major_group = 17;       
	else if Major = 'SOCIAL SCIENCES' then major_group = 17;       
	else if Major = 'SOCIAL STUDIES' then major_group = 17;       
	else if Major = 'SOCIAL STUDIES COMPREHENSIVE' then major_group = 17;       
	else if Major = 'POLITICAL SCIENCE, CRIMINAL JUSTICE OPT' then major_group = 17; 
	else if Major = 'MEDIEVAL STUDIES' then major_group = 17;  
	else if Major = 'GLOBAL STUDIES' then major_group = 17;  
	else if Major = 'INTL STUDIES: EUROPE' then major_group = 17;  
	else if Major = 'LIB ARTS - INTNATL STUDIES(AA)' then major_group = 17;  
	else if Major = 'MASTER OF INTL MGMT' then major_group = 17; 
	else if Major = 'MASTER OF ARTS IN THE SOCIAL SCIENCES' then major_group = 17;   
	else if Major = 'INTR STDY SOC SCI-INTL STUDIES' then major_group = 17;
	else if Major = '-GEOGRAPHY, URBAN-ECONOMIC-' then major_group = 17;
        else if Major = "ANTH: MUSEUM STUDIES (MA)" then major_group = 17;
        else if Major = "GEN STUDIES-HUMANITIES/SOC SCI" then major_group = 17;
        else if Major = "GLOBAL AFFAIRS" then major_group = 17;
        else if Major = "GLOBAL POLICY STUDIES 05-06" then major_group = 17;
        else if Major = "GOVERNMENT/INT'L AFFAIRS" then major_group = 17;
        else if Major = "GROUP SOCIAL STUDIES" then major_group = 17;
        else if Major = "HIST/POL SCI INTER" then major_group = 17;
        else if Major = "HISTORIC PRESERV PLANNING" then major_group = 17;
        else if Major = "HISTORIC PRESERV/COMM PLANNING" then major_group = 17;
        else if Major = "HISTORIC PRESERVATION" then major_group = 17;
        else if Major = "HUMANTIES" then major_group = 17;
        else if Major = "IS SOCIAL SCIENCE" then major_group = 17;
        else if Major = "L A: HUMANITIES AND SOC SCI" then major_group = 17;
        else if Major = "L.A. HUMANITIES" then major_group = 17;
        else if Major = "L.A. SOCIAL SCIENCE" then major_group = 17;
        else if Major = "LIB ARTS & SCI-SOCIAL SCIENCE" then major_group = 17;
        else if Major = "LIBERAL ARTS SCI HUM SOCSCI" then major_group = 17;
        else if Major = "LIBERAL ARTS-HUM & SOC SCI AA" then major_group = 17;
        else if Major = "LIBERAL ARTS/SCI-HUM/SOCSCI" then major_group = 17;
        else if Major = "LIBERAL ARTS: SOCIAL AND BEHAVIOR SCIENCE" then major_group = 17;
        else if Major = "MUSEUM PROFESSIONS" then major_group = 17;
        else if Major = "MUSEUM STUDIES" then major_group = 17;
        else if Major = "MUSEUM STUDIES (CERT)" then major_group = 17;
        else if Major = "POL SCI/AM POLITICS & POLICY" then major_group = 17;
        else if Major = "POLITICS & GOVERNMENT MAJOR" then major_group = 17;
        else if Major = "PROTECT SERV - POL SCI MJR" then major_group = 17;
        else if Major = "SOCIAL SCIENCE - INTERDISCIPLINARY" then major_group = 17;
        else if Major = "SOCIAL SCIENCE BA" then major_group = 17;
        else if Major = "SOCIAL SCIENCE FIELD ENDORSEMENT" then major_group = 17;
        else if Major = "SOCIAL STUDIES COMPOSITE" then major_group = 17;
        else if Major = "SOCIAL THOUGHT & ANALYSIS" then major_group = 17;


/*  Health professions and related sciences */
	else if Major = 'ALCOHOL/DRUGS COUNSELING' then major_group = 18;
	else if Major = 'AUDIOLOGY' then major_group = 18; 
	else if Major = 'DRUG & ALCOHOL REHAB COUNSELOR' then major_group = 18; 
	else if Major = 'MENTAL HEALTH' then major_group = 18;   
	else if Major = 'DOCTOR OF MEDICINE' then major_group = 18;  
  	else if Major = 'DOCTOR OF OSTEOPATHIC MEDICINE' then major_group = 18;  
  	else if Major = 'GERONTOLOGY' then major_group = 18;
	else if Major = 'MD PROGRAM' then major_group = 18; 
	else if Major = 'MEDICAL' then major_group = 18;  
	else if Major = 'MEDICAL MICRO & IMMUN BS' then major_group = 18;  
	else if Major = 'MEDICAL MICROBIOLOGY & IMM' then major_group = 18; 
	else if Major = 'OSTEOPATHIC MEDICINE' then major_group = 18;  
	else if Major = 'MEDICINE' then major_group = 18;  
	else if Major = 'MEDICINE (M.D.)' then major_group = 18;  
	else if Major = 'MEDICINE - CHICAGO' then major_group = 18;  
	else if Major = 'MERIDIA HURON HOSPITAL' then major_group = 18;  
	else if Major = 'DENTISTRY' then major_group = 18;  
	else if Major = 'PHLEBOTOMIST' then major_group = 18;  
	else if Major = 'PHLEBOTOMY' then major_group = 18;  
	else if Major = 'PHLEBOTOMY TECHNICIAN' then major_group = 18;  
	else if Major = 'NUCLEAR MEDICINE TECH' then major_group = 18;  
	else if Major = 'NUCLEAR MEDICINE TECHNOLOGY' then major_group = 18; 
	else if Major = 'DIAGNOSTIC ULTRASOUND' then major_group = 18;   
	else if Major = 'DIETETICS' then major_group = 18;  
	else if Major = 'FAM/CONS SCI-DIETETICS' then major_group = 18;  
	else if Major = 'HSC RADIATION THERAPY BS' then major_group = 18;  
	else if Major = 'HUMAN MEDICINE' then major_group = 18;  
	else if Major = 'MASSAGE THERAPY' then major_group = 18; 
	else if Major = 'RN COMPLETION' then major_group = 18;  
	else if Major = 'REHABILITATION MED (PHYSICAL THERAPY)' then major_group = 18;  
	else if Major = 'REHABILITATION SERV, BACHELOR' then major_group = 18;  
	else if Major = 'REHABILITATION SERVICES' then major_group = 18;  
	else if Major = 'REHABILITIVE SERVICES' then major_group = 18;  
	else if Major = 'PRE-PHYSICAL THERAPY' then major_group = 18;  
	else if Major = 'PHYSICIAN ASSISTANT' then major_group = 18;  
	else if Major = 'PHYSICAN ASSISTANT STUDIES' then major_group = 18;  
	else if Major = 'PHYS THERAPY-BS' then major_group = 18;  
	else if Major = 'PHYSICAL THERAPIST ASSISTANT' then major_group = 18;  
	else if Major = 'PHYSICAL THERAPY' then major_group = 18;  
	else if Major = 'PARAMEDIC TECHNICIAN D' then major_group = 18;  
	else if Major = 'PARAMEDIC' then major_group = 18; 
	else if Major = 'MASTER OF PHYSICAL THERAPY' then major_group = 18; 
	else if Major = 'RESPIRATORY CARE' then major_group = 18;  
	else if Major = 'RESPIRATORY THERAPY' then major_group = 18; 
	else if Major = 'OCCUPATIONAL THERAPY' then major_group = 18;  
	else if Major = 'OCCUPATIONAL THERAPY ASSIST.' then major_group = 18;  
	else if Major = 'OCCUPATIONAL THERAPY ASSISTANT' then major_group = 18;  
	else if Major = 'OCCUPATIONAL THERAPY ASST(CER)' then major_group = 18;  
	else if Major = 'OCCUPTNL THER ASST' then major_group = 18;  
	else if Major = 'OCCUPATIONAL SCIENCE/OCCUPATIONAL THERAPY (MS)' then major_group = 18;  
	else if Major = 'OCCUPATIONAL SCIENCE/OCCUPATIONAL THERAPY - B.S.' then major_group = 18; 
	else if Major = 'MED RAD TECH (RAD THERAPY)' then major_group = 18; 
	else if Major = 'MUSC THRY PED' then major_group = 18; 
	else if Major = 'PT POST PROFESSIONAL' then major_group = 18;
	else if Major = 'PRE-PHYSICAL THERAPY' then major_group = 18; 
	else if Major = 'MD04 RADIOLOGIC TECHNOLOGY' then major_group = 18;  
	else if Major = 'AAS-RADIOGRAPHY' then major_group = 18;  
	else if Major = 'MED RAD TECH (RAD THERAPY)' then major_group = 18;  
	else if Major = 'RADIOLOGIC TECHNOLOGY' then major_group = 18;  
	else if Major = 'RADIOGRAPHY' then major_group = 18;  
	else if Major = 'RAD TECH & MED IMAG' then major_group = 18;   
	else if Major = 'OPTICAL APPRENTICE' then major_group = 18;   
	else if Major = 'CERTIFICATE/GERONTOLOGY' then major_group = 18;  
	else if Major = 'CERTIFIED MEDICATION AIDE' then major_group = 18;  
	else if Major = 'SURGICAL TECHNOLOGY' then major_group = 18;  
	else if Major = 'SURGICAL TECHNOLOGIST' then major_group = 18; 
	else if Major = 'DRP 6-YEAR PHAR D' then major_group = 18;  
 	else if Major = 'VISION SCIENCE' then major_group = 18;  
	else if Major = 'REHAB COUNSELING, MASTER' then major_group = 18;  
	else if Major = 'REHABILITATION COUNSELING' then major_group = 18; 
	else if Major = 'COMMUNITY COUNSELING' then major_group = 18;  
	else if Major = 'COU COUNSELING' then major_group = 18;  
	else if Major = 'COUNSELING' then major_group = 18;  
	else if Major = 'COUNSELING AND HUMAN SERVICES' then major_group = 18;  
	else if Major = 'COUNSELING/COMMUNITY' then major_group = 18; 
	else if Major = 'COMM SCI & DISORDERS (BA)' then major_group = 18; 
	else if Major = 'VOCATIONAL REHABILITATION' then major_group = 18;
	else if Major = 'SECOND CAREER NURSING' then major_group = 18;    
	else if Major = 'PHARMACY ADMINISTRATION' then major_group = 18;  
	else if Major = 'B A - COMMUNICATION, COMM DISORDER CONC' then major_group = 18; 
	else if Major = 'CD SPEECH AND LANGUAGE PATHLGY' then major_group = 18; 
	else if Major = 'CLINICAL SPEECH PATHOLOGY (MS)' then major_group = 18;
	else if Major = 'COMM DISORDERS & SPEECH SCI' then major_group = 18;
	else if Major = 'COMMUNICATION DISORDERS' then major_group = 18;
	else if Major = 'COMMUNICATION SCI & DISORDERS' then major_group = 18;
	else if Major = 'COMMUNICATION SCIENCES & DISORDERS' then major_group = 18;
	else if Major = 'COMMUNICATION SCIENCES AND DISORDERS' then major_group = 18;
	else if Major = 'COMMUNICATION DISORDERS             LRE T 1220' then major_group = 18;
	else if Major = 'COMMUNICATIVE DISORDERS' then major_group = 18;
	else if Major = 'COMMUNICATIVE DISORDERS BS' then major_group = 18;
	else if Major = 'COMMUNICATIVE DISORDERS BSE' then major_group = 18;
	else if Major = 'COMMUNICATIVE DISORDERS MA' then major_group = 18;
	else if Major = 'COMMUNICATIVE DISORDERS             CODI' then major_group = 18;
	else if Major = 'COMMUNICATION DISORDERS BS' then major_group = 18;
	else if Major = 'COMMUNICATION DISORDERS BSE' then major_group = 18;
	else if Major = 'COMMUNICATION DISORDERS MA' then major_group = 18;
	else if Major = 'FOOD AND NUTRITIONAL SCIENCES - DIETETICS AND FOOD ADMINISTRATION OPTION' then major_group = 18;
        else if Major = 'HEALTH ADMINISTRATION' then major_group = 18;
        else if Major = 'HEALTH CARE MANAGEMENT' then major_group = 18;
        else if Major = 'HEALTH SCI - HEALTH SERV ADMIN' then major_group = 18;
        else if Major = 'HEALTH CARE MANAGEMENT' then major_group = 18;
        else if Major = 'HEALTH POLICY AND MANAGEMENT' then major_group = 18;
        else if Major = 'HEALTH CARE OFFICE M' then major_group = 18;
        else if Major = 'HEALTH SCIENCE:  HEALTH ADMINISTRATION AND' then major_group = 18;
        else if Major = 'HEALTH SERVICES ADMINISTRATION' then major_group = 18;
        else if Major = 'HEALTH SYSTEMS MANAGEMENT' then major_group = 18;
        else if Major = 'HEALTHCARE ADMINISTRATION' then major_group = 18;
        else if Major = 'HEALTHSERVICESMANAGEMENT' then major_group = 18;
        else if Major = 'HEALTH INFORMATION MANAGEMENT' then major_group = 18;
        else if Major = 'MAJOR: SPEECH-LANGUAGE PATHOLOGY' then major_group = 18;
        else if Major = 'MAJOR: SPEECH-LANGUAGE-HEARING' then major_group = 18;
        else if Major = 'P/S*SPEECH PATH. AND AUDIOLOGY' then major_group = 18;
        else if Major = 'SPEECH & LANGUAGE PATHOLOGY' then major_group = 18;
        else if Major = 'SPEECH AND HEARING HANDICAPPED' then major_group = 18;
        else if Major = 'SPEECH AND HEARING SCIENCES' then major_group = 18;
        else if Major = 'SPEECH PATH & AUDIO' then major_group = 18;
        else if Major = 'SPEECH PATH & AUDIOLOGY' then major_group = 18;
        else if Major = 'SPEECH PATHOLOGY' then major_group = 18;
        else if Major = 'SPEECH PATHOLOGY AND AUDIOLOGY' then major_group = 18;
        else if Major = 'SPEECH,LANG,HEARING SCIENCES' then major_group = 18;
        else if Major = 'SPEECH-LANGUAGE AND AUDITORY PATHOLOGY' then major_group = 18;
        else if Major = 'SPEECH-LANGUAGE PATHOLOGY' then major_group = 18;
        else if Major = 'SPEECH/HEARING SCIENCE B A' then major_group = 18;
        else if Major = 'SPEECH/HEARING THERAPY AID' then major_group = 18;
        else if Major = 'SPEECH/LANG IMP - CLINICAL' then major_group = 18;
        else if Major = 'SPEECH/LANGUAGE PATHOLOGY' then major_group = 18;
        else if Major = 'EMERGENCY MED TECH' then major_group = 18;
        else if Major = 'EMERGENCY MEDICAL SERVICES' then major_group = 18;
        else if Major = 'EMERGENCY MEDICAL TECHNICIAN' then major_group = 18;
        else if Major = 'EMERGENCY MEDICAL TECHNICIAN - PARAMEDIC (EMT-P)' then major_group = 18;
        else if Major = 'EMERGENCY MEDICAL TECHNICIAN B' then major_group = 18;
        else if Major = 'EMERGENCY MEDICAL TECHNICIAN-BASIC APPLIED TECH DIPLOMA' then major_group = 18;
        else if Major = 'EMERGENCY MEDICAL TECHNICIAN-PARAMEDIC' then major_group = 18;
        else if Major = 'HELENE FULD SCHOOL OF NURSING' then major_group = 18;
        else if Major = 'PSYCHIATRIC TECHNICIAN CERT' then major_group = 18;
        else if Major = 'PHARMACY TECHNICIAN' then major_group = 18;
        else if Major = 'VETERINARY SCIENCE TECHNOLOGY' then major_group = 18;
        else if Major = 'VETERINARY TECHNOLOGY' then major_group = 18;
        else if Major = 'MARRIAGE & FAMILY THERAPY' then major_group = 18;
        else if Major = 'MARRIAGE AND FAMILY THERAPY' then major_group = 18;
        else if Major = 'NURSING ASSISTANT/HOME HEALTH AIDE' then major_group = 18;
        else if Major = 'MFAMILY NURSE PRACTITIONER' then major_group = 18;
        else if Major = 'MULTI-SKILLED HEALTH TECH.' then major_group = 18;
        else if Major = 'HEALTH INFORMATION TECH' then major_group = 18;
        else if Major = 'HEALTH INFORMATION TECHNOLOGY' then major_group = 18;
        else if Major = 'MEDICAL RECORDS TECHNOLOGY' then major_group = 18;
        else if Major = 'MEDICAL TECHNOLOGY' then major_group = 18;
        else if Major = 'MEDICAL LAB TECHNOLOGY' then major_group = 18;
        else if Major = 'MEDICAL RECORDS ADMIN.' then major_group = 18;
        else if Major = 'AAS.ADNB' then major_group = 18;
        else if Major = 'AAS.RESC' then major_group = 18;
        else if Major = 'ADDICTION COUNSELING' then major_group = 18;
        else if Major = 'ADDICTION STUDIES' then major_group = 18;
        else if Major = 'ADM & SUPERVISION, MED' then major_group = 18;
        else if Major = 'ADV PRACTICE RESPIRA THERAPIST' then major_group = 18;
        else if Major = 'ADVANCED MASSAGE THERAPY' then major_group = 18;
        else if Major = 'ADVANCED PRACTITIONER' then major_group = 18;
        else if Major = 'ADVANCED RADIOLOGIC SCIENCES' then major_group = 18;
        else if Major =	'ALTERNATE TRACK - VT RN' then major_group = 18;
        else if Major =	'ANESTHESIA' then major_group = 18;
        else if Major =	'ASSOCIATE IN APPLIED SCIENCE IN PHYSICAL THERAPIST ASSISTANT' then major_group = 18;
        else if Major =	'ASSOCIATE IN APPLIED SCIENCE IN RESPIRATORY THERAPIST' then major_group = 18;
        else if Major =	'B.S. RADIOLOGIC SCIENCES' then major_group = 18;
        else if Major =	'BASIC ARRHYTHMIA RECOGNITION COURSE' then major_group = 18;
        else if Major =	'CERT EMT-BASIC' then major_group = 18;
        else if Major =	'CHIRO' then major_group = 18;
        else if Major =	'CHIROPRACTIC' then major_group = 18;
        else if Major =	'COGNITIVE IMPAIRMENT' then major_group = 18;
        else if Major =	'COGNITIVE SCIENCE PHD' then major_group = 18;
        else if Major =	'CONCEPTUAL FDS OF MEDICINE' then major_group = 18;
        else if Major =	'COUNSPERSSERV - MED - STUDPERS' then major_group = 18;
        else if Major =	'DENTISTRY (IDP)' then major_group = 18;
        else if Major =	'DENTISTRY - DDS' then major_group = 18;
        else if Major =	'DENTISTRY, DDS' then major_group = 18;
        else if Major =	'DENTISTRY-PRE' then major_group = 18;
        else if Major =	'DIAG MED SONO AB/OB' then major_group = 18;
        else if Major =	'DIAG MED SONOGRAPHY/ULTRA' then major_group = 18;
        else if Major =	'E PHYSICAL THERAPY' then major_group = 18;
        else if Major =	'ELECTROCARDIOGRAPHIC & CARDIAC' then major_group = 18;
        else if Major =	'EMOT/BEHAVIORAL DISORDER' then major_group = 18;
        else if Major =	'EMT - BASIC' then major_group = 18;
        else if Major =	'EMT - PARAMEDIC' then major_group = 18;
        else if Major =	'EMT BASIC' then major_group = 18;
        else if Major =	'EMT-P CERT' then major_group = 18;
        else if Major =	'EMT/BASIC' then major_group = 18;
        else if Major =	'EMT: BASIC' then major_group = 18;
        else if Major =	'ENDODONTICS' then major_group = 18;
        else if Major =	'ENTRY LEVEL PHYSICAL THERAPY' then major_group = 18;
        else if Major =	'FCS: DIETETICS' then major_group = 18;
        else if Major =	'GRAD PHYSICAL THERAPY DPT' then major_group = 18;
        else if Major =	'GRAD-TCHG CHLD WITH LD' then major_group = 18;
        else if Major =	'GRADUATE-P.A.' then major_group = 18;
        else if Major =	'HLTH INFORMATICS & INFO MGMT' then major_group = 18;
        else if Major =	'HLTH PROM MGMT - LEISURE/EXER MGMT FOCUS' then major_group = 18;
        else if Major =	'HLTH STUDIES:PHYS ACTVTY-EXERC' then major_group = 18;
        else if Major =	'HLTH, KINES & LEIS STUDIES' then major_group = 18;
        else if Major =	'HUMAN MOVEMENT' then major_group = 18;
        else if Major =	'HUMAN PHYSIOLOGY' then major_group = 18;
        else if Major =	'IMAGING SCIENCE SERVICES ASST' then major_group = 18;
        else if Major =	'KINESIOLOGY, MOVEMENT STUDIES EMPHASIS' then major_group = 18;
        else if Major =	'KINESIOLOGY/MOVEMENT SCIENCE' then major_group = 18;
        else if Major =	'LPN' then major_group = 18;
        else if Major =	'LPN/ADN BRIDGE PROG' then major_group = 18;
        else if Major =	'LVN' then major_group = 18;
        else if Major =	'M.D.' then major_group = 18;
        else if Major =	'M.S.OCCUPATIONAL THERAPY' then major_group = 18;
        else if Major =	'MAJOR IN MEDICINE' then major_group = 18;
        else if Major =	'MAJOR IN PHYSICAL THERAPY' then major_group = 18;
        else if Major =	'MAJOR: ENDODONTICS' then major_group = 18;
        else if Major =	'MAJOR: PHYSIOLOGY' then major_group = 18;
        else if Major =	'MASSAGE THERAPIST' then major_group = 18;
        else if Major =	'MASSAGE THERAPY 57 CR 720 HRS NIGHT' then major_group = 18;
        else if Major =	'MASSAGE THERAPY 750 HRS. DIPL. US V03' then major_group = 18;
        else if Major =	'MASSAGE THERAPY CERT' then major_group = 18;
        else if Major =	'MASSAGE THERAPY I' then major_group = 18;
        else if Major =	'MASSAGE THERAPY II' then major_group = 18;
        else if Major =	'MASSAGE THERAPY-PDCER' then major_group = 18;
        else if Major =	'MASTER IN OCCUPATIONAL THERAPY' then major_group = 18;
        else if Major =	'MASTER OF SCIENCE IN OCCUPATIONAL THERAPY' then major_group = 18;
        else if Major =	'MASTER OF SCIENCE IN PHYSICIAN ASSISTANT STUDIES' then major_group = 18;
        else if Major =	'MED CODING & INSURANCE BILLING' then major_group = 18;
        else if Major =	'MED CODING/ REIMBURS SPECIALST' then major_group = 18;
        else if Major =	'MED ENROLLMENT - 1 CONCENTRATION-08' then major_group = 18;
        else if Major =	'MEDICINE - MD' then major_group = 18;
        else if Major =	'MEDICINE - TULSA MD' then major_group = 18;
        else if Major =	'MEDICINE M D' then major_group = 18;
        else if Major =	'MEDICINE MD' then major_group = 18;
        else if Major =	'MEDICINE, MD, SHREVE' then major_group = 18;
        else if Major =	'MEDICINE-MD MD' then major_group = 18;
        else if Major =	'MEDICINE-URBANA' then major_group = 18;
        else if Major =	'MENT HLTH/ADDICT STD/DEV DISB' then major_group = 18;
        else if Major =	'MENTALLY/PHYSICALLY HANDICAPPED' then major_group = 18;
        else if Major =	'MODERATE DISABILITIES (MED)' then major_group = 18;
        else if Major =	'MS IN REHAB SCI/PT' then major_group = 18;
        else if Major =	'MSN: ADULT/ACUTE CNS TRACK' then major_group = 18;
        else if Major =	'NRS PRACT:PEDIATRIC ACUTE CARE' then major_group = 18;
        else if Major =	'OCCUPATIONAL THERAPY ASSIST' then major_group = 18;
        else if Major =	'OCCUPATIONAL THERAPY ASST' then major_group = 18;
        else if Major =	'OCCUPATIONAL THERAPY BSHS/MSOT' then major_group = 18;
        else if Major =	'OCCUPATIONAL TRAINING AND DEV' then major_group = 18;
        else if Major =	'OPTICIANRY' then major_group = 18;
        else if Major =	'OPTICIANS ASSISTANT' then major_group = 18;
        else if Major =	'OPTOMETRY' then major_group = 18;
        else if Major =	'OPTOMETRY OD' then major_group = 18;
        else if Major =	'ORTHODONTICS' then major_group = 18;
        else if Major =	'PARAMEDIC PROGRAM' then major_group = 18;
        else if Major =	'PARAMEDIC SCIENCE' then major_group = 18;
        else if Major =	'PARAMEDICINE - CERTIFICATE OF COMPLETION' then major_group = 18;
        else if Major =	'PATIENT CARE ASSISTANT' then major_group = 18;
        else if Major =	'PATIENT CARE ASSISTING' then major_group = 18;
        else if Major =	'PEDIATRIC DENTISTRY' then major_group = 18;
        else if Major =	'PEDIATRIC NP PRIMARY CARE' then major_group = 18;
        else if Major =	'PEDIATRIC NUR PRAC-ACUTE CARE' then major_group = 18;
        else if Major =	'PERSONAL TRAINER' then major_group = 18;
        else if Major =	'PHLEBOTOMY (CERTIFICATE)' then major_group = 18;
        else if Major =	'PHLEBOTOMY CERT' then major_group = 18;
        else if Major =	'PHLEBOTOMY CERTIFICATE' then major_group = 18;
        else if Major =	'PHLEBOTOMY CRT' then major_group = 18;
        else if Major =	'PHLEBOTOMY MSA' then major_group = 18;
        else if Major =	'PHLEBOTOMY SKILLS-CERT' then major_group = 18;
        else if Major =	'PHYS THERAPIST ASST' then major_group = 18;
        else if Major =	'PHYS THERAPIST ASST (1+1)' then major_group = 18;
        else if Major =	'PHYS THERAPIST ASST(2-YEAR)' then major_group = 18;
        else if Major =	'PHYSICAL THERAPIST ASST.' then major_group = 18;
        else if Major =	'PHYSICAL THERAPY (TWO YEAR PROGRAM)' then major_group = 18;
        else if Major =	'PHYSICAL THERAPY ASSISTANT' then major_group = 18;
        else if Major =	'PHYSICAL THERAPY ASSISTANT *' then major_group = 18;
        else if Major =	'PHYSICAL THERAPY ASSISTANT, AAS' then major_group = 18;
        else if Major =	'PHYSICAL THERAPY ASSISTING' then major_group = 18;
        else if Major =	'PHYSICAL THERP ASST' then major_group = 18;
        else if Major =	'PHYSICIAN ASSISTANT MASTERS TRACK' then major_group = 18;
        else if Major =	'PHYSICIAN ASSISTANT STUDIES' then major_group = 18;
        else if Major =	'PHYSICIAN ASSISTANT, BS' then major_group = 18;
        else if Major =	'PODIATRIC MEDICINE' then major_group = 18;
        else if Major =	'POLYSOMNOGRAPHIC' then major_group = 18;
        else if Major =	'PRE PHYSICAL THERAPY' then major_group = 18;
        else if Major =	'PRE-BSN' then major_group = 18;
        else if Major =	'PRE-RESPIRATORY THERAPY' then major_group = 18;
        else if Major =	'PRIMARY CARE PNP' then major_group = 18;
        else if Major =	'RADIATION & IMAGING' then major_group = 18;
        else if Major =	'RADIATION SCIENCE' then major_group = 18;
        else if Major =	'RADIATION SCIENCES' then major_group = 18;
        else if Major =	'RADIOGRAPHY AS' then major_group = 18;
        else if Major =	'REHABILITATION SCIENCES' then major_group = 18;
        else if Major =	'REHABILITATIVE SERVICES' then major_group = 18;
        else if Major =	'RESPIRATORY THERAPIST' then major_group = 18;
        else if Major =	'RESPIRATORY THERAPY - AAS' then major_group = 18;
        else if Major =	'SEVERE DISABILITIES' then major_group = 18;
        else if Major =	'ST-ADVANCED MASSAGE THERAPY' then major_group = 18;
        else if Major =	'THERAPEUTIC MASSAGE' then major_group = 18;
        else if Major =	'VASCULAR ULTRASOUND' then major_group = 18;
        else if Major =	'ASN' then major_group = 18;
        else if Major =	'ESOHM-INDUSTRIAL HYG EM' then major_group = 18;
        else if Major =	'MT' then major_group = 18;
        else if Major =	'NMED' then major_group = 18;
        else if Major =	'NSG, ASN COMPL CONC-LPNS' then major_group = 18;
        else if Major =	'OLD MOVEMENT STUDIES' then major_group = 18;
        else if Major =	'PN STUDIES - OWENS' then major_group = 18;
        else if Major =	'TDPT-BSPT TRANSITION TO DPT' then major_group = 18;
        else if Major = 'DOCTOR OF AUDIOLOGY' then major_group = 18;
        else if Major = 'DOCTOR OF PHYSICAL THERAPY, SH' then major_group = 18;
        
/*  Legal professions and studies */
	else if Major = 'JURIS DOCTOR DAY' then major_group = 19;  
	else if Major = 'LAW SCHOOL' then major_group = 19; 
	else if Major = 'LAW SCHOOL - JD' then major_group = 19; 
	else if Major = 'JUSTICE STUDIES' then major_group = 19; 
	else if Major = 'LAW & JUSTICE' then major_group = 19; 
	else if Major = 'LAW AND JUSTICE' then major_group = 19; 
	else if Major = 'PUBLIC JUSTICE BA' then major_group = 19; 
	else if Major = 'SOC OF LAW/CRIMINOL/DEVIANC BA' then major_group = 19; 
	else if Major = 'SOC-CRIMINAL JUSTICE' then major_group = 19; 
	else if Major = 'AMERICAN LEGAL SYSTEM' then major_group = 19; 
	else if Major = 'TAXATION' then major_group = 19; 
        else if Major = 'AGRICULTURAL LAW' then major_group = 19;
        else if Major = 'HEALTH LAW' then major_group = 19;
        else if Major = 'DUAL JD/MBA: LAW AND BUSINESS' then major_group = 19;
        else if Major = 'JURIS DOCTOR' then major_group = 19;
        else if Major = 'JURIS DOCTORATE' then major_group = 19;
        else if Major = 'JURIS DOCTORJD' then major_group = 19;
        else if Major = 'JURISPRUDENCE' then major_group = 19;
        else if Major = 'NEGOTIATION DISPUTE RESOLUTION' then major_group = 19;

/*  Mathematics and statistics */
	else if Major = 'STATISTICAL SCIENCE - PHD' then major_group = 20;  
	else if Major = 'STATISTICS' then major_group = 20;  
	else if Major = 'STATISTICS                         STAT      17021' then major_group = 20;  
	else if Major = 'STATISTICS - MS' then major_group = 20;  
	else if Major = 'ACTUARIAL SCIENCE' then major_group = 20;  
        else if Major = 'ANALYTICS' then major_group = 20;
        else if Major = 'PREDICTIVE ANALYTICS' then major_group = 20;
        
/* Mechanic and repair technologies */
	else if Major = 'HVACR TECHNOLOGY' then major_group = 21; 
	else if Major = 'MAINT/MILLWRT APPR   50-423-1' then major_group = 21;    
  	else if Major = 'ASSOCIATE OF APPLIED SCIENCE DIESEL TECHNOLOGY' then major_group = 21;    
	else if Major = 'CERTIFICATE DIESEL TECHNOLOGY' then major_group = 21;  
  	else if Major = '44 CREDIT HOUR DIPLOMA DIESEL TECHNOLOGY' then major_group = 21; 
  	else if Major = 'DIESEL TECHNOLOGY' then major_group = 21;  
  	else if Major = 'DIESEL MECHANICS TECH' then major_group = 21;  
	else if Major = 'HEAVY EQUIPMENT TECHNOLOGY' then major_group = 21;  
	else if Major = 'BODY & FENDER 70 VTC' then major_group = 21;  
	else if Major = 'AUTO MAINT TECH      31-404-3' then major_group = 21;  
	else if Major = 'AUTOMOTIVE MECHANICS TECHNICIAN' then major_group = 21;  
	else if Major = 'AUTOMOTIVE SERVICE TECHNICIAN' then major_group = 21;  
	else if Major = 'AUTOMOTIVE SERVICE TECH-DIP' then major_group = 21; 
	else if Major = 'AUTOMOTIVE TECHNICIAN' then major_group = 21;  
	else if Major = 'COMPUTER REPAIR TECHNOLOGY' then major_group = 21; 
	else if Major = 'COMPUTER SUPPORT TECHNICIAN' then major_group = 21; 
	else if Major = 'PC REPAIR TECHNICIAN' then major_group = 21; 
	else if Major = 'PC CONFIGURATION AND REPAIR' then major_group = 21; 
	else if Major = 'TELECOM WIRING & INSTALLATION' then major_group = 21; 
	else if Major = 'INDUSTRIAL MAINTENANCE' then major_group = 21; 
	else if Major = "*INDUSTRIAL MAINTENANCE*" then major_group = 21; 
	else if Major = "*STEAMFITTING (ABC)" then major_group = 21; 
	else if Major = 'ACFT MAINT (AS ONLY)' then major_group = 21; 
        else if Major = 'AIRFRAME & POWERPLANTMECHANICS' then major_group = 21;
        else if Major = 'BASIC MACHINING' then major_group = 21;
        else if Major = 'COMMERCIAL ELECTRICAL MAINT' then major_group = 21;
        else if Major = 'DIESEL BRAKE & FRONT-END SPECI' then major_group = 21;
        else if Major = 'DIESEL EQUIPMENT MECHANIC' then major_group = 21;
        else if Major = 'DOMESTIC AIR COND & FURNACE' then major_group = 21;
        else if Major = 'INDUSTRIAL MAINT' then major_group = 21;
        else if Major = 'INDUSTRIAL MAINTENANCE' then major_group = 21;
        else if Major = 'INDUSTRIAL MECHANIC' then major_group = 21;
        else if Major = 'INDUSTRIAL MECHANICAL SYSTEMS' then major_group = 21;
        else if Major = 'JEWELRY MANUFACTURING AND REPAIR - DIP' then major_group = 21;
        else if Major = 'MACHINE REPAIR APPRENTICESHIP' then major_group = 21;
        else if Major = 'MACHINE TOOL OPERATION' then major_group = 21;
        else if Major = 'MACHINING PROCESSES' then major_group = 21;
        else if Major = 'MECHANICS AND MAINTENANCE' then major_group = 21;
        else if Major = 'MILLWRIGHT APPRENTICESHIP' then major_group = 21;
        else if Major = 'CUSTODIAL MAINTENANCE' then major_group = 21;
        
/*  Natural sciences */
  	else if Major = 'ASTROPHYSICAL SCIENCES PH.D.' then major_group = 22;  
  	else if Major = 'MAJOR IN PHYSICS' then major_group = 22;  
	else if Major = 'PHYSICS' then major_group = 22;  
  	else if Major = 'SCIENCE' then major_group = 22;  
	else if Major = 'EARTH SYSTEMS (BS)' then major_group = 22;  
	else if Major = 'EARTH-SPACE SCIENCE' then major_group = 22;  
	else if Major = 'BSED ELU/EARTH SPACE SCI' then major_group = 22;  
	else if Major = 'NAT SCIENCE-PHYSICAL SCI' then major_group = 22;
	else if Major = 'ATMOSPHERIC SCIENCES' then major_group = 22;  
  	else if Major = 'APPLIED PHYSICS' then major_group = 22;   
  	else if Major = 'APPLIED SCIENCE' then major_group = 22;  
  	else if Major = 'APPLIED SCIENCE - PUBLIC AGENCY SERVICE' then major_group = 22;  
	else if Major = 'INTEGRATED SCIENCE PROGRAM' then major_group = 22; 
	else if Major = 'CHEMISTRY:BUSINESS CONCENTRATION' then major_group = 22;  
        else if Major = 'APPLIED PLANT SCIENCES M S' then major_group = 22;
        else if Major = 'APPLIED SCIENCE - AA' then major_group = 22;
        else if Major = 'APPLIED SCIENCES' then major_group = 22;
        else if Major = 'AS ASSOCIATE IN SCIENCE' then major_group = 22;
        else if Major = 'AS-SCIENCE' then major_group = 22;
        else if Major = 'ASSOCIATE IN APPLIED SCIENCE' then major_group = 22;
        else if Major = 'ASSOCIATE IN SCIENCE DEGREE' then major_group = 22;
        else if Major = 'ATMOSPHERIC & OCEANIC SCIENCE' then major_group = 22;
        else if Major = 'BRAIN AND COGNITIVE SCIENCES' then major_group = 22;
        else if Major = 'EARTH AND PLANETARY SCIENCE' then major_group = 22;
        else if Major = 'EARTH SCIENCES' then major_group = 22;
        else if Major = 'ENTOMOLOGY-M' then major_group = 22;
        else if Major = 'HYDROLOGY' then major_group = 22;
        else if Major = 'INTERDIS-MEDIT ARCHEOLOGY (BA)' then major_group = 22;
        else if Major = 'LABORATORY SCIENCE CRT' then major_group = 22;
        else if Major = 'METEOROLOGY' then major_group = 22;
        else if Major = 'OCEANOGRAPHY' then major_group = 22;
        else if Major = 'PHYSICAL SCIENCES' then major_group = 22;
        else if Major = 'PHYSICS MS' then major_group = 22;
        else if Major = 'PHYSICS-BS' then major_group = 22;
        else if Major = 'PHYSICS-MS NON THESIS' then major_group = 22;
        else if Major = 'PLANT PHYSIOLOGY' then major_group = 22;
        else if Major = 'PLANT SCIENCE' then major_group = 22;
        else if Major = 'SCIENCE (A.A. & S.)' then major_group = 22;
        else if Major = 'SCIENCE (AS)' then major_group = 22;
        else if Major = 'SCIENCE AS' then major_group = 22;
        else if Major = 'UNIVERSAL SCIENCE' then major_group = 22;
        else if Major = 'VITICULTURE & ENOLOGY' then major_group = 22;
        else if Major = 'BOARD OF GOVERNORS AAS-ACCEPT' then major_group = 22;

        
/* Parks, recreation, and leisure studies */
	else if Major = 'KINESIOLOGICAL SCIENCES' then major_group = 23;  
	else if Major = 'KINESIOLOGY' then major_group = 23;  
	else if Major = 'KINESIOLOGY - BS' then major_group = 23;  
	else if Major = 'KINESIOLOGY B S' then major_group = 23;  
	else if Major = 'KINESIOLOGY MS' then major_group = 23; 
	else if Major = 'APPLIED KINESIOLOGY M ED' then major_group = 23;  
	else if Major = 'ATHLETIC TRAINING' then major_group = 23;  
	else if Major = 'KPE ATHLETIC TRAINING BA' then major_group = 23; 
	else if Major = 'RECR MGT & YTH L' then major_group = 23;  
	else if Major = 'REC & LEISURE ST:GEN REC ADM' then major_group = 23;  
	else if Major = 'RECR MGT & YTH L' then major_group = 23;  
	else if Major = 'REC & LEISURE ST:GEN REC ADM' then major_group = 23;  
	else if Major = 'REC: COMMERCIAL REC & FAC MGMT' then major_group = 23; 
	else if Major = 'MOVEMENT SCIENCE' then major_group = 23;  
	else if Major = 'MOVEMENT STUDIES' then major_group = 23;  
	else if Major = 'MOVEMENT STUDIES IN DISABILITY' then major_group = 23; 
	else if Major = 'LEISURE STUDIES' then major_group = 23;    
	else if Major = 'PHYS ED & EXERCISE SCIENCE' then major_group = 23;  
	else if Major = 'PARK AND RECREATION MANAGEMENT' then major_group = 23; 
	else if Major = 'PARKS AND RECREATION MANAGEMENT' then major_group = 23;
	else if Major = 'PARKS, RECREATION, AND TOURISM MANAGEMENT (COMMUNITY LEISURE SERVICES)' then major_group = 23;
        else if Major = 'PARKS, RECREATION, AND TOURISM MANAGEMENT (SPORT MANAGEMENT)' then major_group = 23;
	else if Major = 'HEALTH AND FITNESS MANAGEMENT' then major_group = 23;
        else if Major = 'PE:RECREATIONAL ADMINISTRATION' then major_group = 23;
        else if Major = 'SPORT ADMINISTRATION' then major_group = 23;
        else if Major = 'SPORT MANAGEMENT' then major_group = 23;
        else if Major = 'SPORTS MANAGEMENT' then major_group = 23;
        else if Major = 'FITNESS TECHNICIAN' then major_group = 23;
        else if Major = 'HEALTH FITNESS' then major_group = 23;
        else if Major = 'HEALTH, PE & RECREATION-RECREATION' then major_group = 23;
        else if Major = 'HEALTH, PE AND RECREATION' then major_group = 23;
        else if Major = 'HEALTH, PHYS ED & RECREATION' then major_group = 23;
        else if Major = 'HEALTH & PHYSICAL ED' then major_group = 23;
        else if Major = 'RECR MGT & YTH L' then major_group = 23;
        else if Major = 'NATURAL RESOURCE RECREATION AND TOURISM' then major_group = 23;
        else if Major = '-KINESIOLOGY, EXERCISE MANAGEMENT-' then major_group = 23;
        else if Major = 'KINESIOLOGY & HEALTH PROMOTION' then major_group = 23;
        else if Major = 'RANGER SERVICES' then major_group = 23;
        else if Major = 'GRAD, OUTDR PRSTS REC' then major_group = 23;
        else if Major = 'ATHLETIC COACHING' then major_group = 23;
        
/* Personal and culinary services */
	else if Major = 'BAKING & PASTRY ARTS' then major_group = 24;  
	else if Major = 'COSMETOLOGY' then major_group = 24;  
	else if Major = 'COSMETOLOGY DAY DIPLOMA' then major_group = 24;  
	else if Major = 'MORTUARY SCIENCE' then major_group = 24;  
        else if Major = 'CULINARY ARTS' then major_group = 24; 
        else if Major = 'CULINARY MGMT, ASSOC.-155' then major_group = 24;
        else if Major = 'FOOD AND BEVERAGE' then major_group = 24;
        else if Major = 'FOOD SANITATION' then major_group = 24;
        else if Major = 'CONSUMER FOODS' then major_group = 24;
        else if Major = 'MANAGEMENT - FUNERAL SERVICES OPTION' then major_group = 24;
        else if Major = 'AS CULINARY ARTS' then major_group = 24;
        else if Major = 'ASSOCIATE IN APPLIED SCIENCE IN BAKING AND PASTRY' then major_group = 24;
        else if Major = 'BAKING AND PASTRY 2' then major_group = 24;
        else if Major = 'CERT-COSMETOLOGY' then major_group = 24;
        else if Major = 'CERTIFICATE OF COMPLETION IN COSMETOLOGY' then major_group = 24;
        else if Major = 'COMMERCIAL CAKE DECORATING' then major_group = 24;
        else if Major = 'COSMETOLOGY & BARBERING' then major_group = 24;
        else if Major = 'COSMETOLOGY (CERTIFICATE)' then major_group = 24;
        else if Major = 'COSMETOLOGY - DIP' then major_group = 24;
        else if Major = 'COSMETOLOGY - TC' then major_group = 24;
        else if Major = 'COSMETOLOGY CERTIFICATE' then major_group = 24;
        else if Major = 'COSMETOLOGY-C' then major_group = 24;
        else if Major = 'CULINARY ARTS-PASTRY CHEF CERT' then major_group = 24;
        else if Major = 'CULINARY SAFETY AND SANITATION' then major_group = 24;
        else if Major = 'DESERT FIELD STUDIES' then major_group = 24;
        else if Major = 'DISC-FOOD SERVICE MGMT' then major_group = 24;
        else if Major = 'FOOD PREPARATION 1' then major_group = 24;
        else if Major = 'FOOD PRODUCTION SPECIALIST' then major_group = 24;
        else if Major = 'FOOD SCIENCE' then major_group = 24;
        else if Major = 'FOOD SCIENCE(BS)' then major_group = 24;
        else if Major = 'FOOD SERVICE' then major_group = 24;
        else if Major = 'FRUIT SCIENCE' then major_group = 24;
        else if Major = 'INTRODUCTION TO BAKING' then major_group = 24;
        else if Major = 'INTRODUCTION TO CHOCOLATE' then major_group = 24;
        else if Major = 'LE CORDON BLEU CULINARY ARTS' then major_group = 24;
        else if Major = 'LE CORDON BLEU PATISSERIE AND BAKING' then major_group = 24;
        else if Major = 'RESTAURANT SKILLS CERTIFICATE                 ' then major_group = 24;
        else if Major = 'RESTT, CULINARY, FOOD SVC MGMT' then major_group = 24;


        
/* Philosophy, religion, and theology */
	else if Major = 'RELIGION' then major_group = 25;
	else if Major = 'RELIGIOUS STUDIES' then major_group = 25;
	else if Major = 'PASTORAL MINISTRY' then major_group = 25; 
	else if Major = 'BIBLE' then major_group = 25; 
        else if Major = 'MAJOR IN PHILOSOPHY' then major_group = 25; 
        else if Major = 'SOCIAL PHILOSOPHY' then major_group = 25; 
        else if Major = 'THE DIVINITY SCHOOL' then major_group = 25; 
        else if Major = 'BA-PASTORAL MINISTRIES' then major_group = 25;
        else if Major = 'BIBLICAL & THEOLOGICAL STUDIES' then major_group = 25;
        else if Major = 'BIBLICAL AND THEOLOGICAL STUDIES' then major_group = 25;
        else if Major = 'BIBLICAL STUDIES' then major_group = 25;
        else if Major = 'CHRISTIAN MINISTRIES/MISSIONS' then major_group = 25;
        else if Major = 'CHRISTIAN MINISTRY' then major_group = 25;
        else if Major = 'CHRISTIAN STUDIES' then major_group = 25;
        else if Major = 'COMPARATIVE RELIGION - CR' then major_group = 25;
        else if Major = 'COMPARATIVE STUDY OF RELIGION' then major_group = 25;
        else if Major = 'INDIVID. STUDIES IN PHILOSOPHY' then major_group = 25;
        else if Major = 'JUDAIC STUDIES' then major_group = 25;
        else if Major = 'M.DIV: PROFESSIONAL MINISTRIES' then major_group = 25;
        else if Major = 'M/MINISTRY' then major_group = 25;
        else if Major = 'MA THEOLOGICAL STUDIES' then major_group = 25;
        else if Major = 'MASTER OF ARTS IN CHRISTIAN MINISTRY' then major_group = 25;
        else if Major = 'MASTER OF ARTS IN RELIGION' then major_group = 25;
        else if Major = 'MINISTRY LEADERSHIP' then major_group = 25;
        else if Major = 'PRE-SEM PASTORAL' then major_group = 25;
        else if Major = 'RELIGION-PHILOSOPHY' then major_group = 25;
        else if Major = 'RELIGION: PASTORAL LEADERSHIP' then major_group = 25;
        else if Major = 'URBAN MINISTRY LEADERSHP' then major_group = 25;

/* Precision production */
	else if Major = 'MACHINE SHOP-CNC' then major_group = 26;   
	else if Major = 'MACHINE TOOL CAD CAM TECH MOLD' then major_group = 26;   
	else if Major = 'MACHINE TOOL TECHNOLOGY' then major_group = 26;   
	else if Major = 'WOODWORKING' then major_group = 26;     

/* Psychology */
	else if Major = 'INDUSTRIAL/ORGANIZAT PSY' then major_group = 27;
	else if Major = 'COGNITIVE SCIENCE' then major_group = 27;
	else if Major = 'CHILD PSYCHOLOGY B A' then major_group = 27;
	else if Major = 'EDUCATIONAL PSYCHOL' then major_group = 27;
	else if Major = 'EDUCATIONAL PSYCHOLOGY' then major_group = 27;
	else if Major = 'EDUCATIONAL PSYCHOLOGY MA' then major_group = 27;
	else if Major = 'EDUCATIONAL&COUNSELING PSYCH' then major_group = 27;
	else if Major = 'PSYCHOLOGY (ELEM)' then major_group = 27;
	else if Major = 'SCHOOL PSYCHOLOGY' then major_group = 27;
	else if Major = 'SCHOOL PSYCHOLOGY                   PSY T 2001' then major_group = 27;
	else if Major = 'SCHOOL PSYCHOLOGY-SPECIALIST' then major_group = 27;
	else if Major = 'CLINICAL PSYCHOLOGY' then major_group = 27;
	else if Major = 'CLINICAL PSYCHOLOGY - MA' then major_group = 27;
	else if Major = 'PSYCHOLOGY:CLINICAL PSYCHOLOGY' then major_group = 27;
	else if Major = 'FAMILY PSYCHOLOGY' then major_group = 27;
	else if Major = 'MAJOR IN SOCIAL SCI (BEHAVIORAL SCIENCE & HEALTH)' then major_group = 27;
        else if Major = 'BEHAVIORAL SCIENCE AA' then major_group = 27;
        else if Major = 'BS BEHAVIORAL SCIENCE MAJOR' then major_group = 27;
        else if Major = 'CONCENTRATION: BEHAVIORAL SCIENCES' then major_group = 27;
        else if Major = 'GEN STUDIES, BEHAVIORAL SCI' then major_group = 27;
        else if Major = 'INTERDISCIPLINARY STUDIES:SOCIAL & BEHAVIORAL SCIENCES OPTION AA' then major_group = 27;
        else if Major = 'LIB ARTS-SOC & BEHAVIORAL SCI' then major_group = 27;
        else if Major = 'PSYC' then major_group = 27;
        else if Major = 'SOCIAL & BEHAVIORIAL SCIENCES' then major_group = 27;
        else if Major = 'SOCIAL AND BEHAVIORAL SCIENCES' then major_group = 27;
        else if Major = 'PREPRO PSYC' then major_group = 27;

/* Public administration and social work */
	else if Major = 'PUBLIC POLICY' then major_group = 28; 
	else if Major = 'PUBLIC POLICY ANALYSIS' then major_group = 28; 
	else if Major = 'PUBLIC POLICY M P P' then major_group = 28; 
	else if Major = 'PUBLIC POLICY STUDIES' then major_group = 28;
	else if Major = 'PLANNING, PUBLIC POLICY & MGMT' then major_group = 28;
	else if Major = 'POLICY STUDIES' then major_group = 28;  
	else if Major = 'PUBLIC COMM SERVICE' then major_group = 28; 
	else if Major = 'MAJOR IN CONSUMER AND COMMUNITY STUDIES' then major_group = 28; 
	else if Major = 'BACHELOR OF SOC WORK' then major_group = 28; 
	else if Major = 'SOCIAL WELFARE BA' then major_group = 28;  
	else if Major = 'SOCIAL WELFARE' then major_group = 28;    
	else if Major = 'HUMAN SERVICES' then major_group = 28;  
	else if Major = 'HUMAN SERVICES (GR)' then major_group = 28;  
	else if Major = "HUMAN SERVICES           AAS-T" then major_group = 28;  
	else if Major = 'HUMAN SERVICES COUNSELING' then major_group = 28;    
	else if Major = 'BACHELOR OF SCIENCE IN HUMAN SERVICES' then major_group = 28;  
	else if Major = 'PUBLIC ADMIN' then major_group = 28; 
	else if Major = 'PUBLIC ADMIN GRAD' then major_group = 28; 
	else if Major = 'PUBLIC ADMINISTRAT' then major_group = 28; 
	else if Major = 'PUBLIC ADMINISTRATION' then major_group = 28; 
	else if Major = 'PUBLIC POLICY ADMINISTRATION' then major_group = 28;
	else if Major = 'PUBLIC POLICY AND ADMIN.' then major_group = 28;
	else if Major = 'PUBLIC POLICY AND MANAGEMENT' then major_group = 28;
        else if Major = 'PUBLIC MANAGEMENT             PM        3252020600' then major_group = 28;
        else if Major = 'PUBLIC & INSTITUTIONAL ADMINISTRATION' then major_group = 28;
        else if Major = 'POL SCI: PUBLIC ADMINISTRATION' then major_group = 28;
        else if Major = 'MAJOR IN PUBLIC SERVICE MANAGEMENT' then major_group = 28;
        else if Major = 'POL SCIENCE IN PUBLIC ADMIN' then major_group = 28;
        else if Major = 'SOCIAL SERVICE ADMINISTRATION' then major_group = 28;
	else if Major = 'WOODROW WILSON M.P.A.' then major_group = 28; 
	else if Major = 'ADM JUS-BASIC PUBLIC SAFETY DISPATCH' then major_group = 28; 
	else if Major = 'ADOLESCENT ADVOCACY' then major_group = 28; 
	else if Major = 'ADVANCED COUNSELING' then major_group = 28; 
        else if Major = 'APPLIED BEHAVIORAL SCI - MA, COUNSELING' then major_group = 28;
        else if Major = 'AS HUMAN SERVICES' then major_group = 28;
        else if Major = 'CERT-CALL CENTER/CUSTOMER SVC' then major_group = 28;
        else if Major = 'CERTIFICATE OF COMPLETION IN BASIC PEACE OFFICER LICENSING' then major_group = 28;
        else if Major = 'CERTIFIED ALCOHOL AND DRUG COUNSELOR' then major_group = 28;
        else if Major = 'CERTIFIED CUSTOMER SERVICE SPE' then major_group = 28;
        else if Major = 'COMMUNITY & HUMAN SERVICES' then major_group = 28;
        else if Major = 'COMMUNITY COUNSELING (MA)' then major_group = 28;
        else if Major = 'COMMUNITY COUNSELING SERVICES' then major_group = 28;
        else if Major = 'COMMUNITY INFORMATICS' then major_group = 28;
        else if Major = 'COMMUNITY SERVICES' then major_group = 28;
        else if Major = 'COMMUNITY STUDIES' then major_group = 28;
        else if Major = 'COUNS-STUDENT DEV HIGHER ED MS' then major_group = 28;
        else if Major = 'COUNSELING & HUMAN SERVICES' then major_group = 28;
        else if Major = 'COUNSELING & PERS SERV SCH CO' then major_group = 28;
        else if Major = 'COUNSELING (G)' then major_group = 28;
        else if Major = 'COUNSELING - COMMUNITY' then major_group = 28;
        else if Major = 'COUNSELING BA' then major_group = 28;
        else if Major = 'COUNSELING MED' then major_group = 28;
        else if Major = 'COUNSELING MS' then major_group = 28;
        else if Major = 'COUNSELING W/CONCENTRATION:COMMUNITYCOUNSELING' then major_group = 28;
        else if Major = 'COUNSELING-SCH CNSLNG (MED)' then major_group = 28;
        else if Major = 'COUNSELING: STATE CREDENTIAL P' then major_group = 28;
        else if Major = 'DEVELOP DIS DIRECT SUPPORT' then major_group = 28;
        else if Major = 'FUNERAL SERVICES' then major_group = 28;
        else if Major = 'FUNERAL SERVICES CERTIFICATE' then major_group = 28;
        else if Major = 'GOVERNMENT CONC. A BA' then major_group = 28;
        else if Major = 'GOVERNMENT CONTRACTING' then major_group = 28;
        else if Major = 'HUM - SOCIAL SERVICES OPTION' then major_group = 28;
        else if Major = 'HUMAN DEVELOPMENT COUNSELING' then major_group = 28;
        else if Major = 'HUMAN SERVICES ����������AAS-T' then major_group = 28;
        else if Major = 'HUMAN SERVICES ASSOCIATE' then major_group = 28;
        else if Major = 'HUMAN SERVICES C45' then major_group = 28;
        else if Major = 'HUMAN SERVICES CERTIFICATE' then major_group = 28;
        else if Major = 'HUMAN SERVICES DEGREE' then major_group = 28;
        else if Major = 'HUMAN SERVICES SPECIALIST' then major_group = 28;
        else if Major = 'HUMAN SERVICES-ASSISTANCE: CUSTOMER SERVICE' then major_group = 28;
        else if Major = 'HUMAN SERVICES-DISTRIBUTIVE' then major_group = 28;
        else if Major = 'HUMAN SERVICES-DRUG/ALCOHOL' then major_group = 28;
        else if Major = 'HUMAN SERVICES: HUMAN SERVICES' then major_group = 28;
        else if Major = 'INCO-COMM. IN HUMAN SERVICES' then major_group = 28;
        else if Major = 'INTERDISCIPLINARY STUDIES - COMMUNITY DEVELOPMENT AND SUSTAINABILITY' then major_group = 28;
        else if Major = 'M.A. IN COUNSELING' then major_group = 28;
        else if Major = 'MA HUMAN SERVICES: HLTH & WELL' then major_group = 28;
        else if Major = 'MAJOR: POLICY ANALYSIS' then major_group = 28;
        else if Major = 'MASTER OF ARTS IN COUNSELING' then major_group = 28;
        else if Major = 'MORTUARY SCIENCE & FUNERAL SRV' then major_group = 28;
        else if Major = 'MORTUARY SCIENCE AND FUNERAL SERVICE' then major_group = 28;
        else if Major = 'MORTUARY SCIENCES' then major_group = 28;
        else if Major = 'MPA - PUBLIC SECTR MGMT/LEADER' then major_group = 28;
        else if Major = 'MS/PUBLIC & NON-PROFIT MGMT.' then major_group = 28;
        else if Major = 'NATIONAL SECURITY AND PUBLIC SAFETY' then major_group = 28;
        else if Major = 'NONPROFIT/HUMAN SERVICES MGMT' then major_group = 28;
        else if Major = 'PEACE OFFICER OF THE STATE OF CALIFORNIA' then major_group = 28;
        else if Major = 'PSA/HUMAN SERV. OPT' then major_group = 28;
        else if Major = 'PUB ADM MA:EMERG MGT' then major_group = 28;
        else if Major = 'PUBLIC & NONPROFIT MGMT & POLICY' then major_group = 28;
        else if Major = 'PUBLIC ADMN' then major_group = 28;
        else if Major = 'PUBLIC AFFAIRS' then major_group = 28;
        else if Major = 'PUBLIC AFFAIRS MPA' then major_group = 28;
        else if Major = 'PUBLIC AFFAIRS, EVENING DEGREE PROGRAM' then major_group = 28;
        else if Major = 'PUBLIC AND PROFESSIONAL WRITNG' then major_group = 28;
        else if Major = 'PUBLIC POLICY ����������������������UEP' then major_group = 28;
        else if Major = "PUBLIC POLICY                       UEP" then major_group = 28;
        else if Major = 'PUBLIC SAFETY DISPATCHER' then major_group = 28;
        else if Major = 'PUPIL PERSONNEL SERVICES: COUNSELING' then major_group = 28;
        else if Major = 'REHABILITATION AND HUMAN SERVICES' then major_group = 28;
        else if Major = 'SOCIAL RELATIONS' then major_group = 28;
        else if Major = 'SOCIAL SERVICES' then major_group = 28;
        else if Major = 'SOCIAL SERVICES COUNSELING' then major_group = 28;
        else if Major = 'SWRK:INTERPERSONAL PRACTICE' then major_group = 28;
        
/* Transportation and materials moving */
	else if Major = 'TRUCK DRIVING (CERTIFICATE)' then major_group = 29;     
	else if Major = 'TRUCK DRIVER TRAINING CDLA I' then major_group = 29;  
	else if Major = 'AIR TRAFFIC CONTROL' then major_group = 29;  
	else if Major = 'PROFESSIONAL PILOT' then major_group = 29;  
        else if Major = 'COMMERCIAL DRIVING' then major_group = 29;
        else if Major = 'COMMERCIAL TRUCK DRIVING' then major_group = 29;
        else if Major = 'COMMERCIAL TRUCK DRIVING -TCC' then major_group = 29;
        else if Major = 'COMMERCIAL TRUCK DRIVING MSHA' then major_group = 29;
        else if Major = 'COMMERCIAL TRUCK DRIVING TCC' then major_group = 29;
        else if Major = 'COMMERICAL DRIVING ENHANCED' then major_group = 29;
        else if Major = 'DRIVER OPERATOR 1A' then major_group = 29;
        else if Major = 'MANUAL DRIVE TRAIN/TRANS/AXLE' then major_group = 29;
        else if Major = 'PROFESSIONAL TRUCK DRIVER' then major_group = 29;
        else if Major = 'RAILROAD CONDUCTOR CERT' then major_group = 29;
        else if Major = 'TRACTOR/TRAILER DRIVER TRAIN' then major_group = 29;
        else if Major = 'TRUCK DRIVER TRAIN CDL BASIC' then major_group = 29;
        else if Major = 'TRUCK DRIVER TRAINING (CERT)' then major_group = 29;
        else if Major = 'TRUCK DRIVING' then major_group = 29;
        else if Major = 'AIRLINE OPERATIONS' then major_group = 29;
        else if Major = 'AIRLINE OPERATIONS: VACATIONS' then major_group = 29;
        else if Major = 'AIRWAY SCIENCE' then major_group = 29;

/*  Visual and performing arts */
	else if Major = 'ARTS                                AAAS 45600' then major_group = 30;  
	else if Major = 'ACTING' then major_group = 30; 
	else if Major = 'ART-GRAPHIC DESIGN' then major_group = 30; 
	else if Major = 'ART/GRAPHIC DESIGN' then major_group = 30; 
	else if Major = 'ARTS' then major_group = 30; 
	else if Major = 'ARTS - ASSOCIATE' then major_group = 30; 
	else if Major = 'AUDIO ARTS AND ACOUSTICS' then major_group = 30; 
	else if Major = 'B A - ARTS APPLICATIONS' then major_group = 30; 
	else if Major = 'CINEMA' then major_group = 30; 
	else if Major = 'CRAFTS' then major_group = 30; 
	else if Major = 'CRAFTS OR FINE ARTS' then major_group = 30; 
	else if Major = 'FA01 FINE ARTS A.S.' then major_group = 30; 
	else if Major = 'FINE & APPLIED ARTS' then major_group = 30; 
	else if Major = 'FINE ARTS' then major_group = 30; 
	else if Major = 'FINE ARTS - CREATIVE ARTS' then major_group = 30; 
	else if Major = 'GRAPHIC APPLICATIONS' then major_group = 30; 
	else if Major = 'GRAPHIC ARTS-PRINT GRAPHICS OPT' then major_group = 30; 
	else if Major = 'GRAPHIC DESIGN' then major_group = 30; 
	else if Major = 'GRAPHIC DESIGN OPT' then major_group = 30; 
	else if Major = 'GRPHIC DSGN & ILLST' then major_group = 30; 
	else if Major = 'ILLUSTRATION' then major_group = 30; 
	else if Major = 'OBOE' then major_group = 30; 
	else if Major = 'PHO PHOTOGRAPHY' then major_group = 30; 
	else if Major = 'PHOTOGRAPHY' then major_group = 30; 
	else if Major = 'THEATER' then major_group = 30; 
	else if Major = 'TV & RADIO (BA)' then major_group = 30; 
	else if Major = 'WIND & PERCUSSION INSTRUMENTS' then major_group = 30; 
	else if Major = 'PAINTING' then major_group = 30;    
	else if Major = 'PROF PHOTOGRAPHIC ILLUSTRATION' then major_group = 30; 
	else if Major = 'INTERIOR DESIGN' then major_group = 30; 
	else if Major = 'COMMERICAL & TECHNICAL ART-DIP' then major_group = 30; 
	else if Major = 'INDUSTRIAL DESIGN' then major_group = 30;  
	else if Major = 'INDUSTRIAL DESIGN, DIGITAL DESIGN TRACK' then major_group = 30; 
	else if Major = 'HUMANITIES & FINE ARTS' then major_group = 30;   
        else if Major = 'FINE ARTS-APPLIED MEDIA ARTS' then major_group = 30;
        else if Major = 'PERF ARTS-THEATER/TECH DESIGN' then major_group = 30;
        else if Major = 'ART: HISTORY' then major_group = 30;
        else if Major = 'HISTORY OF ART MS' then major_group = 30;
        else if Major = 'MAJOR: HISTORY OF ART' then major_group = 30;
        else if Major = 'ACTOR TRAINING' then major_group = 30;
        else if Major = 'ANIMATION' then major_group = 30;
        else if Major = 'ART(BFA)' then major_group = 30;
        else if Major = 'ART-BFA' then major_group = 30;
        else if Major = 'ART-PRINTMAKING EMPHASIS' then major_group = 30;
        else if Major = 'ASSOCIATE DEGREE IN ARTS' then major_group = 30;
        else if Major = 'ASSOCIATE IN FINE ARTS' then major_group = 30;
        else if Major = 'ASSOCIATE OF ARTS-007' then major_group = 30;
        else if Major = 'BM PIANO' then major_group = 30;
        else if Major = 'CERAMICS' then major_group = 30;
        else if Major = 'CINEMA AND DIGITAL ARTS*' then major_group = 30;
        else if Major = 'CINEMA AND PHOTOGRAPHY' then major_group = 30;
        else if Major = 'CREATIVE ARTS IN THERAPY' then major_group = 30;
        else if Major = 'DANCE' then major_group = 30;
        else if Major = 'ESTHETICS-CERT' then major_group = 30;
        else if Major = 'FA01 FINE ARTS' then major_group = 30;
        else if Major = 'GNST ASSOCIATE OF ARTS (9000)' then major_group = 30;
        else if Major = 'GRAPHIC DESIGN (AS)' then major_group = 30;
        else if Major = 'GRAPHIC DESIGN-EVE/WKND' then major_group = 30;
        else if Major = 'ILLUSTRATION-EVE/WEEKEND' then major_group = 30;
        else if Major = 'IMAGING/DIGITAL ARTS - MFA' then major_group = 30;
        else if Major = 'INSTRUMENTAL/BM' then major_group = 30;
        else if Major = 'JAZZ' then major_group = 30;
        else if Major = 'MAJOR: FINE ARTS' then major_group = 30;
        else if Major = 'MAJOR: PIANO' then major_group = 30;
        else if Major = 'MAJOR: SCULPTURE' then major_group = 30;
        else if Major = 'PDG PIANO' then major_group = 30;
        else if Major = 'PIANO' then major_group = 30;
        else if Major = 'PRINTMAKING' then major_group = 30;
        else if Major = 'PROFESSIONAL PHOTOGRAPHY' then major_group = 30;
        else if Major = 'SCULPTURE' then major_group = 30;
        else if Major = 'THEATER(BA)' then major_group = 30;
        else if Major = 'TRANSFORMATIVE ARTS' then major_group = 30;
        else if Major = 'UNIVERSAL ARTS' then major_group = 30;
        else if Major = 'WOODWINDS' then major_group = 30;

        
/* LIBERAL ARTS */
	else if Major = 'ASSOCIATE IN LIBERAL STUDIES' then major_group = 31; 
	else if Major = 'LIB ARTS & SCI: HUM & SOC SCI' then major_group = 31;       
	else if Major = 'LIB ARTS & SCIENCE' then major_group = 31;       
	else if Major = 'LIB ARTS AND SCI' then major_group = 31;       
	else if Major = 'LIB ARTS- HUMANITIES & SOCIAL SCIENCES' then major_group = 31;       
	else if Major = 'LIB ARTS:SOC SC/HUM' then major_group = 31;       
	else if Major = 'LIBERAL ARTS' then major_group = 31;       
	else if Major = 'LIBERAL ARTS & SCI' then major_group = 31;       
	else if Major = 'LIBERAL ARTS & SCIENCE' then major_group = 31;       
	else if Major = 'LIBERAL ARTS & SCIENCES' then major_group = 31;       
	else if Major = 'LIBERAL ARTS & SCIENCES (AA)' then major_group = 31;       
	else if Major = 'LIBERAL ARTS (4)' then major_group = 31;       
	else if Major = 'LIBERAL ARTS (AA)' then major_group = 31;       
	else if Major = 'LIBERAL ARTS - AA' then major_group = 31;       
	else if Major = 'LIBERAL ARTS AND SCIENCES' then major_group = 31;       
	else if Major = 'LIBERAL ARTS AND SCIENCES (HASS)' then major_group = 31;       
	else if Major = 'LIBERAL ARTS AND SCIENCES - I' then major_group = 31;       
	else if Major = 'LIBERAL ARTS AND SCIENCES AA' then major_group = 31;       
	else if Major = 'LIBERAL ARTS HUMANITIES & SOCIAL SCIENCE' then major_group = 31;       
	else if Major = 'LIBERAL ARTS SCIENCES' then major_group = 31;       
	else if Major = 'LIBERAL ARTS SOCIAL SCIENCE' then major_group = 31;       
	else if Major = 'LIBERAL ARTS TRANFER' then major_group = 31;       
	else if Major = 'LIBERAL ARTS-PACE' then major_group = 31;       
	else if Major = 'LIBERAL ARTS/SCIENCES-SOC SCIE' then major_group = 31;       
	else if Major = 'LIBERAL ARTS: HUMANITIES' then major_group = 31;       
	else if Major = 'LIBERAL STUDIES' then major_group = 31;       
	else if Major = 'LIBERAL STUDIES' then major_group = 31;       
	else if Major = 'LIBERAL STUDIES (GST)' then major_group = 31;       
	else if Major = 'LIBERAL STUDIES ITEP BA' then major_group = 31;       
	else if Major = 'LIBERAL STUDIES TRACK I BA' then major_group = 31; 
	else if Major = 'SOC SCI/HUM - LIB ARTS & SCI' then major_group = 31; 
	else if Major = 'LIBERAL STUDIES                    ALS       49012' then major_group = 31; 
	else if Major = 'PROFESSIONAL & LIBERAL STUDIES' then major_group = 31;  
	else if Major = 'LIBERAL STUDIES (HUTCHINS SCHOOL)' then major_group = 31; 
	else if Major = 'LIBERAL ART' then major_group = 31; 
	else if Major = 'GEN COLLEGE CURRICULUM' then major_group = 31; 
	else if Major = 'GEN LIBERAL ARTS & SCIENCE' then major_group = 31;       
	else if Major = 'GEN STUDIES-ARTS/HUMANITIES' then major_group = 31; 
	else if Major = 'ASSOC OF ARTS - LIBERAL ARTS' then major_group = 31; 
	else if Major = 'ASSOCIATE IN LIBERAL STUDIES' then major_group = 31; 
	else if Major = 'ARTS & SCIENCES' then major_group = 31;       
	else if Major = 'ARTS AND LETTERS' then major_group = 31;       
	else if Major = 'ARTS AND SCIENCES' then major_group = 31; 
	else if Major = 'APPLIED ARTS & SCIENCES' then major_group = 31;
	else if Major = 'LA/SCI/HUMANITIES AA' then major_group = 31;  
	else if Major = 'HUMAN/SOC SCIENCES' then major_group = 31; 
	else if Major = 'OTHER LIBERAL ARTS' then major_group = 31; 
	else if Major = 'LIBERAL EDUCATION' then major_group = 31;  
	else if Major = 'HUMANITIES & SOCIAL SCIENCE' then major_group = 31;       
	else if Major = 'HUMANITIES & SOCIAL SCIENCES' then major_group = 31;      
	else if Major = 'LIBERAL ARTS/SCIENCES-MATH/SCI' then major_group = 31;
	else if Major = 'LA & SCI-MATH-SCI' then major_group = 31;          
	else if Major = 'INTRDSCPLNY LIB ART & SCI' then major_group = 31;    
	else if Major = 'LIBERAL ARTS TRANSFER' then major_group = 31;    
	else if Major = '2YR LETTERS, ARTS, AND SCIENCES' then major_group = 31;    
	else if Major = '2YR LETTERS, ARTS, AND SCIENCES (EXT ACCESS)' then major_group = 31;    
        else if Major = 'AA' then major_group = 31;
        else if Major = 'AA DEGREE' then major_group = 31;
        else if Major = 'AA, ASSOCIATE IN ARTS' then major_group = 31;
        else if Major = 'AA, LIBERAL ARTS & SCIENCES' then major_group = 31;
        else if Major = 'AA-LIBERAL ARTS' then major_group = 31;
        else if Major = 'AA.FMGT' then major_group = 31;
        else if Major = 'AA.LIBA' then major_group = 31;
        else if Major = 'AABA ENROLLMENT - 1 CONCENTRATION-09' then major_group = 31;
        else if Major =	'APPLIED / LIBERAL ARTS STUDIES' then major_group = 31;
        else if Major =	'APPLIED ARTS &AMP; SCIENCES' then major_group = 31;
        else if Major =	'APPLIED ARTS AND SCIENCES' then major_group = 31;
        else if Major =	'APPLIED LIBERAL ARTS' then major_group = 31;
        else if Major =	'ARTS AND SCIENCE' then major_group = 31;
        else if Major =	'ASSOC IN ARTS/SCI                           ' then major_group = 31;
        else if Major =	'BA LIBERAL STUDIES' then major_group = 31;
        else if Major =	'INTERDISCIPLINARY ARTS & SCIENCES (PV)' then major_group = 31;
        else if Major =	'INTERDISCIPLINARY LIBERAL ARTS & SCIENCES' then major_group = 31;
        else if Major =	'INTERDISCIPLINARY STUDIES: �ARTS AND HUMANITIES AA' then major_group = 31;
        else if Major =	"INTERDISCIPLINARY STUDIES:  ARTS AND HUMANITIES AA" then major_group = 31;
        else if Major =	'LETTERS, ARTS, AND SCIENCES' then major_group = 31;
        else if Major =	'LIBERAL ARTS & MGT UG ACRT' then major_group = 31;
        else if Major =	'LIBERAL ARTS & SCI-HUM & SSCI' then major_group = 31;
        else if Major =	'LIBERAL ARTS & SCI. (AA)' then major_group = 31;
        else if Major =	'LIBERAL ARTS & SCIEN' then major_group = 31;
        else if Major =	'LIBERAL ARTS & SCIENCES (VARIOUS)' then major_group = 31;
        else if Major =	'LIBERAL ARTS (AGEC-A)' then major_group = 31;
        else if Major =	'LIBERAL ARTS AND SCIENCE (AA)' then major_group = 31;
        else if Major =	'LIBERAL ARTS MAJOR (BA)' then major_group = 31;
        else if Major =	'LIBERAL ARTS TRANS' then major_group = 31;
        else if Major =	'LIBERAL ARTS WV' then major_group = 31;
        else if Major =	'LIBERAL ARTS-AA' then major_group = 31;
        else if Major =	'LIBERAL ARTS/ SCIENCE' then major_group = 31;
        else if Major =	'LIBERAL SCIENCES' then major_group = 31;
        else if Major =	'LIBERAL STUDIES (BA)' then major_group = 31;
        else if Major =	'LIBERAL STUDIES - AA' then major_group = 31;
        else if Major =	'LIBERAL STUDIES BLS' then major_group = 31;
        else if Major =	'LIBERAL STUDIES ONLINE' then major_group = 31;
        else if Major =	'LIBERAL STUDIES-ENV STUDIES' then major_group = 31;
        else if Major =	'LIBERAL STUDIES: PROFESSION BS' then major_group = 31;
        else if Major =	'REGENTS BACHELOR OF ARTS' then major_group = 31;
        else if Major =	'W/EMPHASIS LIBERAL ARTS & SCI' then major_group = 31;
        else if Major =	'AS.GMSC' then major_group = 31;
        else if Major =	'LIB ARTS-MACRAO CT' then major_group = 31;
        else if Major =	'NO MAJOR ASSOCIATED WITH AA' then major_group = 31;
        else if Major =	'NON-SPECIFIC (AA DEG AWARDED)' then major_group = 31;
        else if Major =	'OCST VOCATIONAL ARTS BS E' then major_group = 31;
        else if Major =	'U. WITHOUT WALLS OFFCAMPUS(BA)' then major_group = 31;
        
/* OTHER */ 
	else if Major = 'A+ CERTIFICATION TRAINING' then major_group = 32;       
	else if Major = 'ACADEMIC STUDIES' then major_group = 32;       
	else if Major = 'APPLIED ARTS & SCIENCES' then major_group = 32;       
	else if Major = 'APPLIED PROFESSIONAL STUDIES' then major_group = 32;       
	else if Major = 'ASSOCIATE IN ARTS                 45600' then major_group = 32;          
	else if Major = 'ASSOC IN ARTS/MN TRAN CURR' then major_group = 32;       
	else if Major = 'ASSOC IN SCIENCE' then major_group = 32;       
	else if Major = 'ASSOC OF SCIENCE - SCIENCES' then major_group = 32;       
	else if Major = 'ASSOCIATE ARTS' then major_group = 32;       
	else if Major = 'ASSOCIATE IN ARTS' then major_group = 32;       
	else if Major = 'ASSOCIATE IN ARTS DEGREE' then major_group = 32;       
	else if Major = 'ASSOCIATE IN SCIENCE' then major_group = 32;       
	else if Major = 'ASSOCIATE OF ARTS' then major_group = 32;       
	else if Major = 'ASSOCIATE OF ARTS AA' then major_group = 32;       
	else if Major = 'ASSOCIATE OF ARTS/NO FOCUS' then major_group = 32;       
	else if Major = 'ASSOCIATE OF SCIENCE' then major_group = 32;       
	else if Major = 'BOARD OF GOVERNORS' then major_group = 32;       
	else if Major = 'CERTIFICATE' then major_group = 32;       
	else if Major = 'CERTIFICATE PROGRAM' then major_group = 32;       
	else if Major = 'COLLEGE SCHOLARS PROGRAM' then major_group = 32;       
	else if Major = 'COMPOSITE INTERDISCIPLINARY' then major_group = 32;       
	else if Major = 'DECLARED NO MAJOR' then major_group = 32;       
	else if Major = 'DIVERSIFIED' then major_group = 32;       
	else if Major = 'DUAL JOINT AA/BA' then major_group = 32;       
	else if Major = 'GENRL AS, PROFESSIONAL STUDIES' then major_group = 32;       
	else if Major = 'GRADUATE CERTIFICATE PROGRAM' then major_group = 32;       
	else if Major = 'HONORS INTERDISCIPLINARY STUDIES' then major_group = 32;  
	else if Major = 'INDEPENDENT' then major_group = 32;       
	else if Major = 'INDEPENDENT MAJOR' then major_group = 32;       
	else if Major = 'INDIVIDUAL PROGRAMS' then major_group = 32;       
	else if Major = 'INDIVIDUAL STUDIES' then major_group = 32;       
	else if Major = 'INDIVIDUALIZED' then major_group = 32;       
	else if Major = 'INDIVIDUALIZED PLANNED PROGRAM' then major_group = 32;       
	else if Major = 'INDIVIDUALIZED STUDIES' then major_group = 32;       
	else if Major = 'INDIVIDUALLY PLANNED' then major_group = 32;       
	else if Major = 'INTERDEPARTMENTAL MAJOR' then major_group = 32;       
	else if Major = 'INTERDISCIPLIN STUDIES' then major_group = 32;       
	else if Major = 'INTERDISCIPLINARY' then major_group = 32;       
	else if Major = 'INTERDISCIPLINARY ARTS & SCIENCES (GS)' then major_group = 32;       
	else if Major = 'INTERDISCIPLINARY ARTS & SCIENCES (PSY)' then major_group = 32;       
	else if Major = 'INTERDISCIPLINARY ST' then major_group = 32;       
	else if Major = 'INTERDISCIPLINARY STUDIES' then major_group = 32;       
	else if Major = 'INTERDISCIPLINARY STUDIES -MA' then major_group = 32;       
	else if Major = 'INTERDISCIPLINARY STUDIES -UG' then major_group = 32;       
	else if Major = 'INTERDISCIPLINARY STUDIES C&I' then major_group = 32;       
	else if Major = 'LDC:  LOWER DIVISION COLLEGIATE' then major_group = 32;       
	else if Major = 'N/A' then major_group = 32;       
	else if Major = 'NA' then major_group = 32;       
	else if Major = 'NO MAJOR' then major_group = 32;       
	else if Major = 'NON-APPLICABLE' then major_group = 32;       
	else if Major = 'NOT APPLICABLE' then major_group = 32;       
	else if Major = 'NOT AVAILABLE' then major_group = 32;       
	else if Major = 'PRE BACHELOR OF ARTS' then major_group = 32;       
	else if Major = 'PREPROFESSIONAL' then major_group = 32;       
	else if Major = 'PREPROFESSIONAL STUDIES' then major_group = 32;       
	else if Major = 'SELECTED STUDIES IN A&S' then major_group = 32;       
	else if Major = 'SPECIAL MAJOR' then major_group = 32;       
	else if Major = 'STANDARD' then major_group = 32;       
	else if Major = 'THREE YEAR DAY DIVISION' then major_group = 32;       
	else if Major = 'TITLE NOT AVAILABLE' then major_group = 32;       
	else if Major = 'UNDERGRADUATE' then major_group = 32;       
	else if Major = 'UNIVERSITY SCHOLAR' then major_group = 32;       
	else if Major = 'UNIVERSITY STUDIES' then major_group = 32;       
	else if Major = 'UNKNOWN' then major_group = 32;  
	else if Major = 'SCI LET & SOCIETY' then major_group = 32;     
	else if Major = 'OTHER SCIENCE' then major_group = 32;     
	else if Major = 'MIS' then major_group = 32;     
	else if Major = 'INTERDISCIPLINARY TECHNOLOGY' then major_group = 32;     
	else if Major = 'MAJOR: ASSOCIATE OF ARTS' then major_group = 32;     
	else if Major = 'MAJOR: ASSOCIATE OF SCIENCE' then major_group = 32;     
	else if Major = 'REGENTS BA DEGREE' then major_group = 32;     
	else if Major = 'INTR STDY SOC SCI-HEALTH STDY' then major_group = 32;     
	else if Major = 'SECONDARY CERTIFICATION' then major_group = 32;     
	else if Major = 'INTRDSCPLNY LIB ART & SCI' then major_group = 32;     
	else if Major = 'INTRDISC STDY BS' then major_group = 32;     
	else if Major = 'INTR STDY SOC SCI-HM RES SCTY' then major_group = 32;     
	else if Major = 'QUAL ASSUR / REG AFFRS' then major_group = 32;             
	else if Major = 'PROFESSIONAL DEVELOPMENT' then major_group = 32;             
	else if Major = 'NAT S PUB HL' then major_group = 32;             
	else if Major = 'ASSOC IN ARTS/MN TRANSFER CURRICULUM' then major_group = 32; 
	else if Major = 'ASSOCIATE IN GENERAL EDUCATION' then major_group = 32; 
	else if Major = 'MINNESOTA TRANSFER CURRICULUM' then major_group = 32; 
	else if Major = 'ENTERPRISE IN SOCIETY (BAILS)' then major_group = 32; 
	else if Major = 'AAS-SURVEYING' then major_group = 32; 
	else if Major = 'ACAD CERT ASSOCIATE OF SCIENCE' then major_group = 32; 
        else if Major = "APPLIED STUDIES" then major_group = 32;
        else if Major = "AS UNIVERSITY PARALLEL" then major_group = 32;
        else if Major = "ASSISTANT" then major_group = 32;
        else if Major = "BA" then major_group = 32;           
        else if Major = "CAMPUS GRADUATE CERTIFICATE" then major_group = 32;
        else if Major = "CERTIFICATION" then major_group = 32;
        else if Major = "CUNY BACCALAUREATE PROGRAM" then major_group = 32;
        else if Major = "CUSTOMER ENERGY SPECIALIST" then major_group = 32;
        else if Major = "DEGREE COMPLETION" then major_group = 32;
        else if Major = "DETAILER" then major_group = 32;
        else if Major = "DIVERSIFIED STUDIES" then major_group = 32;
        else if Major = "EQUEST. STUDIES/WESTERN" then major_group = 32;
        else if Major = "FULL TIME DAY" then major_group = 32;
        else if Major = "GEN COURSE" then major_group = 32;
        else if Major = "HONORS PLAN" then major_group = 32;
        else if Major = "HPE: SPRT/REC PROG *MDM" then major_group = 32;
        else if Major = "HS DIPLOMA" then major_group = 32;
        else if Major = "INDIVIDUAL MAJOR" then major_group = 32;
        else if Major = "INDIVIDUALIZED BA" then major_group = 32;
        else if Major = "INDIVIDUALIZED MAJOR" then major_group = 32;
        else if Major = "INDIVIDUALIZED STUDIES PROGRAM" then major_group = 32;
        else if Major = "INDUSTRY COOP ED PROGRAM" then major_group = 32;
        else if Major = "INSURANCE CUSTOMER SERVICE REPRESENTATIVE" then major_group = 32;
        else if Major = "INTD STDS-C&I" then major_group = 32;
        else if Major = "INTEGRATED STUDIES                           " then major_group = 32;
        else if Major = "INTEGRATIVE STUDIES" then major_group = 32;
        else if Major = "INTERDISCIPLINARY SCIENCES                   " then major_group = 32;
        else if Major = "INTERDISCIPLINARY STUDIES (K-8)" then major_group = 32;
        else if Major = "INTERDISCIPLINARY STUDIES - MA" then major_group = 32;
        else if Major = "INTERDISCIPLINARY STUDIES - UG" then major_group = 32;
        else if Major = "INTERDISCIPLINARY STUDIES -GR" then major_group = 32;
        else if Major = "INTERDISCIPLINARY STUDIES MA" then major_group = 32;
        else if Major = "INTERDISCIPLINARY STUDIES UNTD" then major_group = 32;
        else if Major = "INTERDISCIPLINARY STUDIES, K-6" then major_group = 32;
        else if Major = "INTERDISCIPLINARY STUDIES-BAIS" then major_group = 32;
        else if Major = "LDC: LOWER DIVISION COLLEGIATE" then major_group = 32;
        else if Major = "LEVEL I SECONDARY LICENSE" then major_group = 32;
        else if Major = "MAJOR IN INTERDISCIPLINARY STUDIES" then major_group = 32;
        else if Major = "MAJOR UNKNOWN" then major_group = 32;
        else if Major = "MASTER OF SCIENCE" then major_group = 32;
        else if Major = "MINORS RECEIVED" then major_group = 32;
        else if Major = "MISSIONS" then major_group = 32;
        else if Major = "MULTI OCCUPATIONAL TRADES" then major_group = 32;
        else if Major = "MULTIPLE SUBJECT" then major_group = 32;
        else if Major = "MULTIPLE SUBJECTS" then major_group = 32;
        else if Major = "NEW GENRES" then major_group = 32;
        else if Major = "NEW PROFESSIONAL STUDIES" then major_group = 32;
        else if Major = "PERSONAL PORTFOLIO OF STUDY" then major_group = 32;
        else if Major = "PERSONALIZED STUDY PROGRAM" then major_group = 32;
        else if Major = "PLAN A" then major_group = 32;
        else if Major = "PRE-BACHELOR OF ARTS" then major_group = 32;
        else if Major = "PROF LICENSING 62.48 CREDIT, JUNE 03" then major_group = 32;
        else if Major = "PROFESSIONAL DEVELOPMENT PGM" then major_group = 32;
        else if Major = "PROFESSIONAL INTERDISCIP. STUD" then major_group = 32;
        else if Major = "PROFESSIONAL STUDIES" then major_group = 32;
        else if Major = "PROGRAM 1" then major_group = 32;
        else if Major = "RBA, REGENTS' DEGREE" then major_group = 32;
        else if Major = "REGENTS BA" then major_group = 32;
        else if Major = "REGENTS BA PROGRAM" then major_group = 32;
        else if Major = "RISK AND PREVENTION" then major_group = 32;
        else if Major = "SCIENTIFIC WORKPLACE PREP" then major_group = 32;
        else if Major = "SCIENTIFIC WORKPLACE PREPARATION" then major_group = 32;
        else if Major = "SINGLE SUBJECT CREDENTIAL" then major_group = 32;
        else if Major = "SPECIAL STUDIES" then major_group = 32;
        else if Major = "SPECIALIZED STUDIES" then major_group = 32;
        else if Major = "SUBJECT AREA SPECIFIC" then major_group = 32;
        else if Major = "TOPICAL MAJOR" then major_group = 32;
        else if Major = "TRAINING SIMULATION CERTIFICATE" then major_group = 32;
        else if Major = "UNDERGRADUATE CONVERSOIN" then major_group = 32;
        else if Major = "UNIVERSITY COLLEGE B A" then major_group = 32;
        else if Major = "UNIVERSITY PARALLEL" then major_group = 32;
        else if Major = "UNIVERSITY STUDIES, 4 YRS" then major_group = 32;
        else if Major = "C1.CIT1" then major_group = 32;
        else if Major = "GS" then major_group = 32;
        else if Major = "N" then major_group = 32;
        else if Major = "NET +" then major_group = 32;
        else if Major = "NO CONCENTRATION" then major_group = 32;
        else if Major = "NO MAJOR REQUIRED" then major_group = 32;
        else if Major = "NON-MAJOR" then major_group = 32;
        else if Major = "NONE" then major_group = 32;
        else if Major = "OGY" then major_group = 32;
        else if Major = "OPTION ONE MAJOR" then major_group = 32;
        else if Major = "TO BE IDENTIFIED" then major_group = 32;
        else if Major = "UNCLASSIFIED" then major_group = 32;
        else if Major = "UNSPECIFIED" then major_group = 32;
        else if Major = "BLANK" then major_group = 32;
        else if Major = "WITH AN ARTS & SCIENCES MINOR" then major_group = 32;
        else if Major = "INTELLIGENCE OPERATIONS" then major_group = 32;
        else if Major = "INTELLIGENCE OPERATIONSSTUDIES" then major_group = 32;
        else if Major = "INTELLIGENCE STUDIES" then major_group = 32;
        else if Major = "MARINE SPECIALIST 108 CR 1500 HRS" then major_group = 32;
        else if Major = "MILITARY RELATED SPECIALTY" then major_group = 32;
        else if Major = "STRATEGIC INTELLIGENCE" then major_group = 32;
        else if Major = "STRATEGIC STUDIES & DEFENSE" then major_group = 32;
        else if Major = "/" then major_group = 32;
        


        /* 1. */  AGRI = "/AGR|ANIMAL|HORT|RANCH|TURF/i";
        /* 2. */  ARCH = "/ARCHITECTURE|ARCHITECTURAL STUDIES|URBAN &|URBAN P/i";
        /* 3. */  AREA = "/GENDER/i";
        /* 4. */  BIO = "/ECOS|ECOL|ENVIR|ZOO|WILD|MARITIME|FOREST|NATUR|FISH|(?<!EDUCATION\/)BIO/i";
        /* 5. */  BUS = "/ACCOUNT|BUS|MARKET|MBA|HUMAN RES|HOTEL|HOSPITALITY|TRAVEL|FINA|"||
                        "(?<!EXERCISE)MANAGEMENT|OFFICE |ADMIN(?!ISTRATION OF JUSTICE| OF JUSTICE)|TRANSPORT/i";
        /* 6. */  COMM = "/JOURN|COMMUNICAT|MEDIA(?! TECH)|TELE|BROAD(?!CASTING TECH)|ADVERT|SPEECH/i";
        /* 7. */  COMMTECH = "/BROADCASTING TECH|CAD SPECIALIST/i";
        /* 8. */  COMP = "/COMPUTER/i";
        /* 9. */  CONST = "/CONST|WELD/i";
        /* 10. */ ENFORCE = "/CRIM|SECURITY STUDIES|CORRECT|ENFORCEMENT|JUSTICE|POLICE|FIRE|EMERGENCY/i";
        /* 11. */ ECON = "/ECON(?!DARY)/i";
        /* 12. */ EDUC = "/EDU|PREK|ELEM|TEACH|CHILD|SEC ED|SECONDARY ED|ELED|EL ED|DIVINITY|SCHOOL|CURR|LIBRARY/i";
        /* 13. */ ENGIN = "/ENGINEERING(?! TECH)|AEROS|ENGR(?! TECH)/i";
        /* 14. */ ENGINTECH = "/DRAFT|AIDED D|TECH/i";
        /* 15. */ ENGLISH = "/ENGLISH|SPAN|LANG/i";
        /* 16. */ CONSUMER = "/NUT|HOME|FAMILY|TEXT|APPAR/i";
        /* 17. */ SOCIALSCI   = "/GEOG|POLITICAL|FOREIGN|(?<!ART )HISTORY|INTERN|ANTHRO|SOCIO|AMER/i";
        /* 18. */ HEALTH = "/PREMED|PRE-MED|MEDICAL|NURS|PHARM|HEALTH|DENTAL|CLINICAL|DEAF|VET/i";
        /* 19. */ LEGAL = "/LEGAL|LAW/i";
        /* 20. */ MATH = "/MATH/i";
        /* 21. */ MECH = "/AUTO MECH| MECHANICS|AUTO/i";
        /* 22. */ NATSCI = "/CHEM|GEO/i";
        /* 23. */ PARKS = "/PARK|RECRE|EXERCISE|FITNESS|RESORT|SPORT|PARK/i";
        /* 24. */ PERSONAL = "/FUNERAL|CULINARY|FOOD/i";
        /* 25. */ PHIL = "/PHIL|THEOL|DIVINITY|/i";
        /* 27. */ PSYCH = "/PSYCH/i";
        /* 28. */ SOCWORK = "/SOCIAL WORK/i";
        /* 29. */ TRANSPORT = "/AVIA|AERON/i";
        /* 30. */ ART = "/VISUAL|DRAMA|PERF|THEATRE|ART |STUDIO|ART:|MUSIC|HUMAN PERFORM|FASHION|FILM/i";
        /* 31. */ LIBERAL = "/GENERAL/i";
        /* 32. */ OTHER = "/MULTIDISCIPLINARY|UNDEC|TRANSFER|INTR STDY|INTRD|SECONDARY CERTIFICATION/i";

	AGRIid = prxparse(AGRI);
	call prxsubstr(AGRIid, Major, position, length);
	if major ne ' ' and major_group = . and length ne 0 then do;
		major_group = 1;
	end;
	call prxfree (AGRIid);

	ARCHid = prxparse(ARCH);
	call prxsubstr(ARCHid, Major, position, length);
	if major ne ' ' and major_group = . and length ne 0 then do;
		major_group = 2;
	end;
	call prxfree (ARCHid);

	AREAid = prxparse(AREA);
	call prxsubstr(AREAid, Major, position, length);
	if major ne ' ' and major_group = . and length ne 0 then do;
		major_group = 3;
	end;
	call prxfree (AREAid);

	BIOid = prxparse(BIO);
	call prxsubstr(BIOid, Major, position, length);
	if major ne ' ' and major_group = . and length ne 0 then do;
		major_group = 4;
	end;
	call prxfree (BIOid);

	BUSid = prxparse(BUS);
	call prxsubstr(BUSid, Major, position, length);
	if major ne ' ' and major_group = . and length ne 0 then do;
		major_group = 5;
	end;
	call prxfree (BUSid);


	COMMid = prxparse(COMM);
	call prxsubstr(COMMid, Major, position, length);
	if major ne ' ' and major_group = . and length ne 0 then do;
		major_group = 6;
	end;
	call prxfree (COMMid);


	COMMTECHid = prxparse(COMMTECH);
	call prxsubstr(COMMTECHid, Major, position, length);
	if major ne ' ' and major_group = . and length ne 0 then do;
		major_group = 7;
	end;
	call prxfree (COMMTECHid);

	COMPid = prxparse(COMP);
	call prxsubstr(COMPid, Major, position, length);
	if major ne ' ' and major_group = . and length ne 0 then do;
		major_group = 8;
	end;
	call prxfree (COMPid);

	CONSTid = prxparse(CONST);
	call prxsubstr(CONSTid, Major, position, length);
	if major ne ' ' and major_group = . and length ne 0 then do;
		major_group = 9;
	end;
	call prxfree (CONSTid);

	ENFORCEid = prxparse(ENFORCE);
	call prxsubstr(ENFORCEid, Major, position, length);
	if major ne ' ' and major_group = . and length ne 0 then do;
		major_group = 10;
	end;
	call prxfree (ENFORCEid);

	ECONid = prxparse(ECON);
	call prxsubstr(ECONid, Major, position, length);
	if major ne ' ' and major_group = . and length ne 0 then do;
		major_group = 11;
	end;
	call prxfree (ECONid);

	EDUCid = prxparse(EDUC);
	call prxsubstr(EDUCid, Major, position, length);
	if major ne ' ' and major_group = . and length ne 0 then do;
		major_group = 12;
	end;
	call prxfree (EDUCid);

	ENGINid = prxparse(ENGIN);
	call prxsubstr(ENGINid, Major, position, length);
	if major ne ' ' and major_group = . and length ne 0 then do;
		major_group = 13;
	end;
	call prxfree (ENGINid);

	ENGINTECHid = prxparse(ENGINTECH);
	call prxsubstr(ENGINTECHid, Major, position, length);
	if major ne ' ' and major_group = . and length ne 0 then do;
		major_group = 14;
	end;
	call prxfree (ENGINTECHid);

	ENGLISHid = prxparse(ENGLISH);
	call prxsubstr(ENGLISHid, Major, position, length);
	if major ne ' ' and major_group = . and length ne 0 then do;
		major_group = 15;
	end;
	call prxfree (ENGLISHid);

	CONSUMERid = prxparse(CONSUMER);
	call prxsubstr(CONSUMERid, Major, position, length);
	if major ne ' ' and major_group = . and length ne 0 then do;
		major_group = 16;
	end;
	call prxfree (CONSUMERid);

	SOCIALSCIid = prxparse(SOCIALSCI);
	call prxsubstr(SOCIALSCIid, Major, position, length);
	if major ne ' ' and major_group = . and length ne 0 then do;
		major_group = 17;
	end;
	call prxfree (SOCIALSCIid);

	HEALTHid = prxparse(HEALTH);
	call prxsubstr(HEALTHid, Major, position, length);
	if major ne ' ' and major_group = . and length ne 0 then do;
		major_group = 18;
	end;
	call prxfree (HEALTHid);

	LEGALid = prxparse(LEGAL);
	call prxsubstr(LEGALid, Major, position, length);
	if major ne ' ' and major_group = . and length ne 0 then do;
		major_group = 19;
	end;
	call prxfree (LEGALid);

	MATHid = prxparse(MATH);
	call prxsubstr(MATHid, Major, position, length);
	if major ne ' ' and major_group = . and length ne 0 then do;
		major_group = 20;
	end;
	call prxfree (MATHid);

	MECHid = prxparse(MECH);
	call prxsubstr(MECHid, Major, position, length);
	if major ne ' ' and major_group = . and length ne 0 then do;
		major_group = 21;
	end;
	call prxfree (MECHid);

	NATSCIid = prxparse(NATSCI);
	call prxsubstr(NATSCIid, Major, position, length);
	if major ne ' ' and major_group = . and length ne 0 then do;
		major_group = 22;
	end;
	call prxfree (NATSCIid);

	PARKSid = prxparse(PARKS);
	call prxsubstr(PARKSid, Major, position, length);
	if major ne ' ' and major_group = . and length ne 0 then do;
		major_group = 23;
	end;
	call prxfree (PARKSid);

	PHILid = prxparse(PHIL);
	call prxsubstr(PHILid, Major, position, length);
	if major ne ' ' and major_group = . and length ne 0 then do;
		major_group = 25;
	end;
	call prxfree (PHILid);

	PSYCHid = prxparse(PSYCH);
	call prxsubstr(PSYCHid, Major, position, length);
	if major ne ' ' and major_group = . and length ne 0 then do;
		major_group = 27;
	end;
	call prxfree (PSYCHid);

	SOCWORKid = prxparse(SOCWORK);
	call prxsubstr(SOCWORKid, Major, position, length);
	if major ne ' ' and major_group = . and length ne 0 then do;
		major_group = 28;
	end;
	call prxfree (SOCWORKid);

	TRANSPORTid = prxparse(TRANSPORT);
	call prxsubstr(TRANSPORTid, Major, position, length);
	if major ne ' ' and major_group = . and length ne 0 then do;
		major_group = 29;
	end;
	call prxfree (TRANSPORTid);

	ARTid = prxparse(ART);
	call prxsubstr(ARTid, Major, position, length);
	if major ne ' ' and major_group = . and length ne 0 then do;
		major_group = 30;
	end;
	call prxfree (ARTid);

	LIBERALid = prxparse(LIBERAL);
	call prxsubstr(LIBERALid, Major, position, length);
	if major ne ' ' and major_group = . and length ne 0 then do;
		major_group = 31;
	end;
	call prxfree (LIBERALid);

	OTHERid = prxparse(OTHER);
	call prxsubstr(OTHERid, Major, position, length);
	if major ne ' ' and major_group = . and length ne 0 then do;
		major_group = 32;
	end;
	call prxfree (OTHERid);

run;

proc contents data = major_list;
run;

proc print data = major_list (obs = 10);
run;

proc sort data = major_list;
  by major_group;
run;

proc freq data = major_list;
  tables major_group / nocum;
  format major_group majcat.;
run;

proc freq data = major_list;
  tables major /nocum;
  by major_group;
  format major_group majcat.;
run;

proc sort nodupkey data = major_list out=nsc.major_list;
  by major;
run;

